I wouldn't use this, but the errors are gone

Dim co As Long
Dim starttimer As Double

c = 0
starttimer = Now()

Do While c = 0
If Range("A2") < "" Then c = 1
If c = 1 Then Exit Do
If Now starttimer + TimeValue("0:30:00") Then GoTo KICKIT
Loop


--
HTH

Bob Phillips

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

"Nicole Seibert" wrote in message
...
Okay. So, I won't user timer. And yes, i know I should be learning the
ActiveX stuff and I will... i about two minutes. But why wouldn't my
original code work -- I didn't use timer?

Thanks,
Nicole

"Leith Ross" wrote:


Hello Nicole,

Your timer is set to run for a maximum of 30 minutes from when it is
started. While your timer is running Excel can't be updated.
Range("A2") won't change until the timer has expired. This is why you
need to use an ActiveX timer or an API timer.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread:
http://www.excelforum.com/showthread...hreadid=561743