View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ingolf Ingolf is offline
external usenet poster
 
Posts: 32
Default Is there a way to WAIT in Excel without using 100% CPU?

Hello, Marc

you could split your macro into two procedures, the first of which
consisting of everything ahead of your application.wait command and the
second one consisting of everything after it. Then, in the first
procedure you could use the application.ontime command to call the
second procedure with a certain time delay. This may also require some
modification concerning the declaration (validation) of variables, but
other than the application.wait command it doesn't require much CPU
utilization.

Regards
Ingolf