VBA to loop through scheduled time and run the macro

Hello,

I have a [Macro Code] where I need it to run based on the list of scheduled time on each row. I would like it automatically loop through the scheduled time in cell [I13:I40] and will run this [Macro Code]

For example:

If cell I13= 10/3/2018 5:00PM, then cell E13 select and active and the [Macro Code] is being executed.

I will have different scheduled time from range I13:I40, as the workbook is opened it should automatically loop through the range and when time is up it will execute the code.

Please help

Hi
I'm not 100% sure this is what you're after, but it may help

I'm assuming a series of dates/time arranged in ascending order in a named range "times". This macro will find the cell with a value before the current time but with the following cell later than the current time:

Please Login or Register  to view this content.

this macro will return all cells with a time earlier than the current time:

Please Login or Register  to view this content.

to run a macro automatically when the spreadsheet opens, call it auto_open

Please Login or Register  to view this content.