Hi MrMerton

In the VBA editor put your curser in your macro.

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"MrMerton " wrote in message ...
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


---
Message posted from http://www.ExcelForum.com/