Hello everyone,
I am ultimately trying to have only my current selection populate the Formula Auditing Watch Window.
To do this, I need to open the Formula Auditing Watch Window, select the top row, hold shift, select the bottom row, select "Delete Watch", select new cells, and select "Add Watch".
Is there a way thru VBA to Open Formula Auditing Watch Window, then Clear the entire contents, then add my current selection?
Any help or knowledge would be appreciated.
Thanks
I am ultimately trying to have only my current selection populate the Formula Auditing Watch Window.
To do this, I need to open the Formula Auditing Watch Window, select the top row, hold shift, select the bottom row, select "Delete Watch", select new cells, and select "Add Watch".
Is there a way thru VBA to Open Formula Auditing Watch Window, then Clear the entire contents, then add my current selection?
Any help or knowledge would be appreciated.
Thanks