Application.Watches Property (Excel)
Returns a Watches object representing a range which is tracked when the worksheet is recalculated.
Syntax
expression .Watches
expression A variable that represents an Application object.
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