Thread: Pause?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pete Fedrowitz Pete Fedrowitz is offline
external usenet poster
 
Posts: 4
Default Pause?

Is there a command to pause a subroutine? Specifically, I try to read data
from a web-page that I have just Refreshed:

Selection.QueryTable.Refresh BackgroundQuery:=False

When the sub bombs at this command, I manually wait a minute or two and try
again and most of the time that works. I want to write an "on error" that
will automatically wait a minute and then try again.

Thanks