VBA PROBLEM - Running Macros!

  • Thread starter Thread starter MrMerton
  • Start date Start date
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
 
Hi MrMerton

In the VBA editor put your curser in your macro.

F5 run your complete macro
F8 run your macro line by line
 
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
 
Thank you so much for this advice. Something so simple has made my lif
so much easier!


Thanks again.

Wil
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
vba macro that allows insertion of symbols at cursor 0
VBA code won't run, even with Macro Security set to Enable All Macors 9
execute .acsup script from VBA macro 3
Refresh Macro to run each day? 2
has Excel software updates disabled VBA functions? 2
Macro doesn't execute fully using shortcut 6
automatically trying to run a macro at a certain time 0

Back
Top