Still having the same trouble. It prints, then finishes the refresh &
calculations.

Thanks for taking to time.

"Don Guillett" wrote:

As always post YOUR code for comments. Could be

application.enableevents=false
code
application.enableevents=true

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Chas" wrote in message
...
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