JumboCactuar
Well-known Member
- Joined
- Nov 16, 2016
- Messages
- 788
- Office Version
- 365
- Platform
- Windows
Hi,
Thinking of ways I can trigger a macro hourly without using application.ontime
application.ontime can cause issues and I don't find it too reliable.
My idea was to have a cell containing current time =Now()-Today()
Then cells with a 1/0 flag for each hour
Worksheet_Change event with if statement like:
If time between 15:00 and 16:00 and flag is 0 then run macro and set flag to 1.
Any other way to approach this?
Macro I'm wanting to do is send an email hourly
Thanks for any input
Thinking of ways I can trigger a macro hourly without using application.ontime
application.ontime can cause issues and I don't find it too reliable.
My idea was to have a cell containing current time =Now()-Today()
Then cells with a 1/0 flag for each hour
Worksheet_Change event with if statement like:
If time between 15:00 and 16:00 and flag is 0 then run macro and set flag to 1.
Any other way to approach this?
Macro I'm wanting to do is send an email hourly
Thanks for any input
Last edited: