Conditional Breakpoint?
Dave,
watches are not kept between sessions, so you have to set them each time you
open the file.
There also Debug.Assert. e.g. depending on what you need:
Debug.Assert myVar = "yadda"
Debug.Assert NOT (myVar = "yadda")
NickHK
"Dave Birley" wrote in message
...
I'm trying to debug a fairly hefty Macro. I need to tell it to break "When
myVar = yadda" so that I can see where it is running off the rails. Excel
Help doesn't even recognize the word "breakpoint" --
AAAAAAAAAAAARGHHHHHHHH!!
--
Dave
Temping with Staffmark
in Rock Hill, SC
|