Watches Property

Returns a Watches object representing a range which is tracked when the worksheet is recalculated.

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