Printing Speed

  • Thread starter Thread starter Charles
  • Start date Start date
C

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A Macro to Print sheets in mult w.books 2
excel 2ooo macro 3
How to best select from image and print full size? 1
Creating a print-macro that'll only print page 1? 2
How to record a macro within a macro 9
Print to specific printer -- macro 2
Printing Report Card 4
Macro to format multiple worksheets 24

Back
Top