Need a little help with my code: Run my code if time falls in category. Thank you for helping.

[pedie]

If time in Cells(1, 1) falls between 1 PM - 1:45 AM next day then call macro1 else no.

Sub timeTRY()
 If Cells(1, 1).Value < "12:00" Then
  MsgBox "Time < 12 PM :)"
   Exit Sub
     Else
    Call Macro1
  End If
End Sub

 

[pedie]

R. What I am trying to do here is that i have a code macro1 that I want to run when the user opens the workbook - it pulls data from web. But the right time to pull data from the site is only between this time (1 PM - 1:45 AM) so i dont want the macro1 to run when the time does not fall between this this given time...now A1 = now()

Thanks again!

 

[Ruddles]

Sub timeTRY()
 
 If Cells(1, 1) >= TimeValue("13:00:00") Or Cells(1, 1) <= TimeValue("01:45:00") Then
   MsgBox "In range"
 Else
   MsgBox "Out of range"
 End If
 
End Sub

 

[pedie]

Ruddles, thank you for helping. it works now. This is what i was looking for.

You have a great day ahead!
Bye now!