As I understand it, Application.Wait does not do resolutions finer than 1
second.
If you ask it to wait until Now+1s, then that point in time may already be
1/2 a second away (or it may be a 1/10 second away or even 9/10 second away)
--
Rob van Gelder -
http://www.vangelder.co.nz/excel
" wrote in
message ...
try this
Application.Wait (Now + TimeValue("0:00:01")/2)
it is closer to one tenth of a second. if i remember
correctly i don't think it changes if you increase the 2
value.
-----Original Message-----
hi all
a really useful & simple bit of code introduces a one
second delay
within a macro
Range("A1").Select
Application.Wait (Now + TimeValue("0:00:01"))
Range("A1").Select
can anybody trump this with a bit of code that gives a
one-tenth of a
second delay please?
or is this the holy grail of code?
rise to the challenge please!?
TIA
matt
*** Sent via Developersdex http://www.developersdex.com
***
Don't just participate in USENET...get rewarded for it!
.