This documentation is archived and is not being maintained.

Application.Watches Property

Office 2007
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.

Visual Basic for Applications
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: