Go to specific cell when actual date & time is between two dates & time

Hi all,

I would like to have a macro that goes to specific cell when actual date & time is between a fixed range of two dates & times

For example, I have columns A and B with a fix range of dates and times:

Example1.JPG

And the goal is that if for example, the actual time is 11/01/2022 18:21, the expected result of the macro is to go to cell C5, because the actual time falls within the range of A5 and B5.

Do you have please any idea how to achieve it?

Thanks you all in advance!!

Demo file attached.

Please Login or Register  to view this content.

When you put code into a standard module it operates by default on the active sheet. In this case that works fine but in general you may need to qualify the sheet references.