Watches.Add Method

Syntax

expression.Add(Source)

expression A variable that represents a Watches object.

Parameters

Name	Required/Optional	Data Type	Description
Source	Required	Variant	The source for the range.

Return Value
A Watch object that represents the new range.

Example

This example creates a summation formula in cell A3 and then adds this cell to the watch facility.

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`

Adds a range which is tracked when the worksheet is recalculated.