Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting an array of worksheets for printing | Excel Programming | |||
Printing Worksheets (Array) | Excel Programming | |||
Building an array of worksheets for printing | Excel Programming | |||
printing an array of worksheets | Excel Discussion (Misc queries) | |||
Sheets(array) method for printing grouped worksheets | Excel Programming |