Conditional Breakpoint?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
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
 
Ah -- so my voyage of self-discovery wasn't the only solution! Thanks.
--
Dave
Temping with Staffmark
in Rock Hill, SC


NickHK said:
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
Click to expand...
 
Back
Top