Watch Interface

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

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
<InterfaceTypeAttribute()> _
<GuidAttribute("00024457-0000-0000-C000-000000000046")> _
Public Interface Watch
'Usage
Dim instance As Watch
[InterfaceTypeAttribute()]
[GuidAttribute("00024457-0000-0000-C000-000000000046")]
public interface Watch

Remarks

The Watch object allows users to verify the accuracy of their models and debug problems they encounter. The Watch object is a member of the Watches collection.

Use the Add method or the Item property of the Watches collection to return a Watch object.

You can specify to remove individual cells from the watch facility by using the Delete method of the Watches collection.

You can also specify to remove all cells from the Watch Window by using the Delete method of the Watches collection.

See Also

Reference

Watch Members

Microsoft.Office.Interop.Excel Namespace