View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
E Oveson[_3_] E Oveson[_3_] is offline
external usenet poster
 
Posts: 12
Default 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