MrExcel Publishing
Your One Stop for Excel Tips & Solutions

long macros (stop and start)

Posted by Andonny on March 30, 2001 3:17 PM

I sometimes have macros with a lot of code and when I want to go back and find out what I did I get lost. Is it possible to run the macro slowly or is it possible to stop the macro and restart it at that point.

Another question. This site has become very big. Will there be more pages sometimes in the future? I have only 2 megabytes a day available and that allows me to load this page once a day.

Thank you for your help

Posted by Gregc on March 30, 2001 4:00 PM

F8 steps line by line through a macro. When you are in a macro you can also put the cursor on a line and goto debug and click Toggle Breakpoint. This stops the macro at a certain spot and you can then F8 through the macro. Also, by puting your cursor over a variable you can see the contents of the variable.