View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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