Make a Macro Run One Command at a Time

  • Thread starter Thread starter W L
  • Start date Start date
W

W L

Windows XP
Office XP

Forgive me in advance if this is a repetitious question. I would like to
know if there is any way to make a very long macro run one command at a
time?
 
WL. Start the macorEditor ( press Alt + F11).
If not yet done : Make the command bar : Debug visible ( View / Toolbars /
check Debug).
Put the cursor in your macro and execute your macro step by step with the
button "Step into" ( hoover with the mouse over the buttons and watch the
tooltips; it normally is the button next to the right of the button with
"hand")

You can switch to the "normal" Excel sheet to see (eventually) result on
your sheet, however the VBE has focus so you can't enter or select anything
on it as long as that is the case.

To "normal" go back to the sheet press the X at top right. This also stops
execution of the macro.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Thank you! I can't tell you what a huge help this tip has been. Now instead
of re-recording huge macros over and over, I can simply run it line by line
and find where my problem line is.
 
Your welcome Wendy.

Don't forget to look a bit further in the Debugger.
It had far more usefull possibility's (breakpoint; run to cursor, watching
variable and so on)
If you know your way in it, helps you save lots of time while debugging.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top