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 |
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 |
All times are GMT +1. The time now is 03:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com