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