Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you get a log of the "thread" of lines used, when your macro run?
Hi,
When a macro run and by calls jump between procedures, it would be great to get a log of the "tread" line by line. That would make it more easy to debug, right? Is there a software or a way to achieve this? /Regards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you get a log of the "thread" of lines used, when your macro run?
You might already know about these methods, but here's some possibilities I
can think of: You could just put a breakpoint at the area that you're interested in, run the code, and then once it's reached your breakpoint, View|Callstack (Ctrl+L). Or you could put Debug.Print "functionname" at the start of each sub/function (or write a program to insert this line in each sub/function for you). Then after running your macro you could View|Immediate Window (Ctrl+G) to see all of the sub/functions that were called. -Erik "Marie J-son" wrote in message ... Hi, When a macro run and by calls jump between procedures, it would be great to get a log of the "tread" line by line. That would make it more easy to debug, right? Is there a software or a way to achieve this? /Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Text Thread "Return" Without Leaving the Cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
Should I generally request "post a poll" when I post a new thread? | Excel Discussion (Misc queries) |