Run if you are in the interval time

[flaviu123]

Hello! How can I automatically run a macro in the time 8:00 AM-23:59PM. I mean, if you make click on the running button and is in the given interval time (which is in the range A1 respectively A2 of Sheet1) to run, and if it is outside the range to leave the Sub.
Thanks in advance!

 

[Momentman]

You could try it this way

Sub RunatTime()
    If Time > Range("A1").Value And Time < Range("A2").Value Then
        'Run macro
    End If
End Sub

 

[flaviu123]

thanks!