Need to execute VBA code @ 9:30:01 exactly

With the Worksheet change macro it will cause an error if it has an entry that Excel cannot interept as a time

Also a Worksheet Change macro will not be triggered on L1 (the cell I used in my code) if L1 has a formula in it.


Note:- There may be times that Excel is busy and will not be able to start to run the macro at the exact second you specified

You need a time and date to schedule a macro with OnTime; otherwise, it will run immediately, since you will have scheduled it to run some time on 1/0/1900.

One reason that Excel might be busy (and the macro not run) if it it gets left in edit mode -- e.g., you put the cursor in the formula bar and leave it there ...