Wait number of seconds in A1
In message of Sun, 5 Jul 2009
21:59:41 in microsoft.public.excel.programming, Howard31
writes
Try this:
Application.Wait Now() + Range("A1").Value
"CLR" wrote in message news:OeLJGJb$JHA.1248
...
Hi All......
If someone would be so kind.......how can this code be modified to
"wait" the number of seconds corresponding to the value in A1?
Application.Wait Now() + 0.000005787037
I would not do it that way. YMMV.
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
....
Sleep Range("A1").Value*1000 ' Untested
--
Walter Briscoe
|