Printing Speed

[Charles]

Hi
I am using a macro in Excel 97 to move fields from a record to a print
template on a second sheet and then print it using the
'ActiveSheet.PrintOut' function.
The macro loops through 100 records, scheduling the reports but takes
forever to print them.
There was a post some time ago with a similar problem and the suggestion was
to disable the refresh screen or something like that.
Any suggestions please.

Charles

 

[Anne Troy]

Hi, Charles. If you're watching the screen perform the task, you can turn it
"off". Place this line just before your print code:
Application.ScreenUpdating=False
Then place this line just after your print code:
Application.ScreenUpdating=True
*******************
~Anne Troy

www.OfficeArticles.com