Cool thanks so much for the help.


Bob Phillips wrote:
If Selection = 0 Or Time = TimeSerial(14, 0, 0) Then
StopTimer
Else
starttimer
End If


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
oups.com...
Hello all. This is my first time joining a group but I have used your
help in the past. I am having a problem with a macro.

I wrote a StartTimer macro that will update a few worksheets from an
access database then copy these sheets to a new workbook and save as an
HTML that can be viewed on my intranet. It updates every 5 minutes
currently until I manually execute the StopTimer macro. I have
included an If Then at the end to stop it once the value of cells to be
updated hits 0. I also want to stop the macro once the time is 2:00
PM. Is this something I should add as an Or to my current If
statement?

This currently what I have. I am not sure how to make the time work
though.

If Selection = 0 Then StopTimer Else StartTimer


Thanks for the help.