Do you actually mean Range("A1") for Range("A1)?

Yes, I did. Apologies for the typo. Didn't even notice when I copied and
pasted it again.

--
Regards

Roger Govier


wrote in message
...
Roger,

Do you actually mean Range("A1") for Range("A1)?

TIA

EagleOne

"Roger Govier" wrote:

Hi

If you have the line of code in your module highlighted, then
DebugAdd
Watch will bring that line up as the default in the watch Window.

Or you could type in =Range("A1)=20
and set to Break on True

If you set the Watch to =Range("A1)
and set Break on Change, then every time the value in cell A1 changes
the code will halt.