Application.Watches Property

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

See also:

• Application Object
• Application Object Members