Excel VBA macro
 

Is there any way to step through a VBA macro line by line to follow what it
is doing in the Excel worksheet (the macro is running without errors but my
results are not as intended)?

I am using Excel 2000 with Visual Basic 6.0.
--
R Ormerod

Excel VBA macro
 

I believe F8 does that.

Paul

"R Ormerod" wrote in message
...
Is there any way to step through a VBA macro line by line to follow what
it
is doing in the Excel worksheet (the macro is running without errors but
my
results are not as intended)?

I am using Excel 2000 with Visual Basic 6.0.
--
R Ormerod

Excel VBA macro
 

By putting your cursor anywhere inside of a routine in your VBE, you can
then use the F8 key to step through each line of code. Note that the code
will only be compiled once, the first time you hit F8. If no compile errors
exist, your first line should be highlighted yellow. Also, in your VBE, you
have a toolbar named Debug, which has some shortcut buttons there for
performing quite a few debugging actions. They are very handy.

And F5 will run your code completely. F9 will set breakpoints (nice for
stop-n-go). Could go on, lots of shortcuts.

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)


"R Ormerod" wrote in message
...
Is there any way to step through a VBA macro line by line to follow what
it
is doing in the Excel worksheet (the macro is running without errors but
my
results are not as intended)?

I am using Excel 2000 with Visual Basic 6.0.
--
R Ormerod