View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Yoam69 Yoam69 is offline
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.