run a macro every minute starting at a specific time and stop at a specific time

Hi there,

Is there a way to create a loop or time interval function that would allow me to run a macro starting at 6am and keep on running every minute and then stopping at 6pm. thank you

regards,

SN

Hi there,

Take a look at the attached workbook and see if it does what you need. It uses the following code in the "ThisWorkbook" VBA CodeModule:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M