simple macro question
 

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

simple macro question
 

Roger

With module open and macro selected DebugStep Into then F8 your way through the
steps.


Gord Dibben MS Excel MVP


On Wed, 24 Jan 2007 13:51:01 -0800, Roger
wrote:

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

simple macro question
 

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...
--
HTH...

Jim Thomlinson


"Roger" wrote:

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