Auto running macro

Hi can anyone tell me how I can make my macro keep repeating itself over and over again with out stopping ?

do
'code
loop

Hi j450n can you explain what I have to do in a little more detail please .

what is your macro supposed to do? can you post some sample code please.
It's not good practice to have an endless looping macro, like all things it needs to end sometime but what condition is needed to make it stop running???

Basically my macro searches cell n to see what time is in it and once it's ten mins before that time it stays red until cell o says yes but it needs to run all day

go into the VBE (Alt+F11) hit f1 (help) and look up the Timer function - this has a good example to do what you need. But you should still consider having some machanism of stopping the endless loop, maybe you could use events like Workbook_Open to start the macro and Workbook_close to end it.

Hope this helps

Regards

J450n