The Watch object represents one Watch in the Watch window (found on the Formulas tab in the Excel interface). Each Watch can be a cell or cell range you need to keep track of as other data on the worksheet changes. A Watch object is an auditing tool similar to the watches you can create in the VBE. Watches do just that: They keep track of a cell or cell range, allowing you to study changes to those cells when other data on the worksheet changes.
The Watches collection contains all the Watch objects that have been set in the application.
Was this article helpful?