Hi,

I don't believe the Watch Window can stop code execution. Are you sure you
mean the Watch Window, this window shows the value of a variable as the macro
executes. This is in the VBE (Visual Basic Editor).
--
Cheers,
Shane Devenshire


" wrote:

2003/2007

What is the correct Watch Window syntax to halt code processing?

I want to have the code halt when:

'Sheet1'!A2 changes value (from blank to i.e. 4)


TIA