object representing a range which is tracked when the worksheet is recalculated.
expression.Watches
expression Required. An expression that returns one of the objects in the Applies To list.
Example
This example creates a summation formula in cell A3, and then adds this cell to the Watch Window.
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