View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gtslabs gtslabs is offline
external usenet poster
 
Posts: 54
Default Error from printing to fast


I am using the following command to print worksheets in a loop:

Worksheets(wsname).printout

When I step thru my code it works fine but when I run it at full speed
it causes Excel to crash.
Is there an alternative to this statement that requires no user
response but waits for the print to happen before the code continues?