Can Application.OnTime be stopped at a specified time

[rhudgins]

I have the following code that starts at a specified time in cell X57 and runs every 30 seconds until the iNumber is reached. Is there a way to change the code to stop at 4:00pm instead of when the specified iNumber is reached?

Please Login or Register  to view this content.

[romperstomper]

Instead of testing the counter, test if Hour(Now()) < 16 before rescheduling.

[rhudgins]

Thanks. If I wanted to change it to 4:15pm then what would the code change to?

If Hour(Now()) < 1615?

[romperstomper]

More like:

Please Login or Register  to view this content.

[rhudgins]

Thank you this works nicely.