View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chas chas is offline
external usenet poster
 
Posts: 40
Default Need a pause in my macro before printing

I have a macro that basically refreshes several queries & performs some other
basic task. I need to add code that will then print a final report (which is
just printing one of the tabs). The problem I'm having is that when I add a
pause, it seems to pause the refreshing process then it ends up printing
before all of the refreshes are complete. Any suggestions, I'm very new to
VBA so I'm sure this is an easy fix that I'm overlooking.

Thanks