Watches.Add Method (Excel)

Adds a range which is tracked when the worksheet is recalculated.

expression .Add(Source)

expression A variable that represents a Watches object.

Parameters

Name

Required/Optional

Data Type

Description

Source

Required

Variant

The source for the range.

Return Value

A Watch object that represents the new range.

This example creates a summation formula in cell A3 and then adds this cell to the watch facility.

Sub AddWatch() 
 
 With Application 
 .Range("A1").Formula = 1 
 .Range("A2").Formula = 2 
 .Range("A3").Formula = "=Sum(A1:A2)" 
 .Range("A3").Select 
 .Watches.Add Source:=ActiveCell 
 End With 
 
End Sub
Show:
© 2014 Microsoft