LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Printing an array of worksheets

When I try to print an array of worksheets, I'm getting multiple print jobs
instead of one. Here is my code:

Dim MyArray As Variant
MyArray = Array("Cover", "Summary", "DailySchedule", "Routes", "Pickups",
"CostSummary", "StdTerms", "Acceptance")
Worksheets(MyArray).PrintOut

Any idea why this happens? If I'm printing to the printer, it's OK. But, I
want to be able to create a single pdf file, for example, and I don't want it
to creates several print jobs.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting an array of worksheets for printing Dkline Excel Programming 0 April 23rd 07 02:58 PM
Printing Worksheets (Array) RobC[_3_] Excel Programming 2 May 25th 06 07:36 PM
Building an array of worksheets for printing DRK Excel Programming 5 August 30th 05 01:56 AM
printing an array of worksheets Marco de Witte Excel Discussion (Misc queries) 4 December 8th 04 03:21 PM
Sheets(array) method for printing grouped worksheets Tom Ogilvy Excel Programming 0 July 17th 03 09:11 PM


All times are GMT +1. The time now is 05:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"