Hi
I would like to make a macro run 10 times a day, half past the hour, between 08:30 and 17:30
I thought it was as simple as adding the following for each time of the day I need it to run within the macro and also in 'ThisWorkbook' object.
etc...Please Login or Register to view this content.
The result I get isn't as expected. The first time runs OK but then each additional time runs more than once as it progresses through each time. So 09:30 runs twice then 10:30 runs 4 times etc...
That's not the behaviour I expected.
I know you can use this code to run every hour from the current time the workbook was opened but that is not the behaviour I want.
How can I achieve what I need please?Please Login or Register to view this content.
Thanks
Bookmarks