Code: Select all
Sub WaitNumberOfSeconds(NumberOfSeconds As Integer)
waitTime = TimeSerial(Hour(Now()), Minute(Now()), Second(Now()) + NumberOfSeconds)
Application.Wait waitTime
End Sub
Code: Select all
Sub WaitNumberOfSeconds(NumberOfSeconds As Integer)
waitTime = TimeSerial(Hour(Now()), Minute(Now()), Second(Now()) + NumberOfSeconds)
Application.Wait waitTime
End Sub