| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Breakpoint?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Breakpoint?
Never mind -- I found it under Watch. GRRRRRRRRRR!
-- Dave Temping with Staffmark in Rock Hill, SC "Dave Birley" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Breakpoint?
Ah -- so my voyage of self-discovery wasn't the only solution! Thanks.
-- Dave Temping with Staffmark in Rock Hill, SC "NickHK" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| breakpoint calculation | Excel Worksheet Functions | |||
| breakpoint calculation | Excel Worksheet Functions | |||
| breakpoint calculation | Excel Worksheet Functions | |||
| Breakpoint ok, no breakpoint messes up... | Excel Programming | |||
| Breakpoint in Worksheet_Change sub | Excel Programming | |||
Hybrid Mode
