Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help (Uppercase multiple ranges?) | Excel Discussion (Misc queries) | |||
question about syntax in a simple macro... | Excel Discussion (Misc queries) | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
How turn off macro security question for workbook with no marcos? | Excel Discussion (Misc queries) | |||
Bob Phillips followup question on text macro | Excel Discussion (Misc queries) |