VBA PROBLEM - Running Macros!

M

MrMerton

Hi,

Does anyone know whether I can run a macro LINE BY LINE. I want to
look at a macro that I have written and work out at which point it is
going wrong. IS THERE A TOOL TO RUN THE MACRO BIT BY BIT?

Many thanks for your help! Sorry if this is a daft question - I have
looked in the VBA help and can't find the answer.

Cheers,

Will
 
R

Ron de Bruin

Hi MrMerton

In the VBA editor put your curser in your macro.

F5 run your complete macro
F8 run your macro line by line
 
P

Paulw2k

I assume you are in the VBE (alt-F11). Make sure your cursor is in the
procedure you wish to test, then use F8 (menu Debug>step into) to do a line
by line run. Also think about using breakpoints (using F9 to set and unset)
to run normally up to a given point.

Regards

Paul
 
M

MrMerton

Thank you so much for this advice. Something so simple has made my lif
so much easier!


Thanks again.

Wil
 
Top