MrExcel Publishing
Your One Stop for Excel Tips & Solutions

pause macro when variable = some value?

Posted by ben on May 17, 2000 2:07 AM

Does anyone know how to pause (for debugging) a macro when a certain variable is a specified value?
Say, in a loop where c is the variable, is there a command along the lines of if c = "blah" then [pause macro]?

Posted by ben on May 17, 2000 2:10 AM

oops, sorry, just worked it out!

amazing what looking in the help files will tell you.