simple macro question

[Guest]

I used to know this, but have been out of the game for a while and am trying
to get back in.

Could one of you explain how I watch a macro work one command at a time, I
think it was called stepping through the macro or something like that. I
have writen/recorded some code and I want to see it work slowly, step by step
and I remember being able to preform each command with a function button,
just can't remember process.

Thanks in advance.
Roger

 

[Gord Dibben]

Roger

With module open and macro selected Debug>Step Into then F8 your way through the
steps.


Gord Dibben MS Excel MVP

 

[Guest]

You can use F8 to execute the macro one line at a time. F9 to set break
points in the exectution and Ctrl + F8 is Run to cursor...