I've never noticed this before, but it seems that printing multiple sheets
always creates multiple print jobs. If I print two spreadsheets and then
look at the printer properties, there are two jobs. So it looks like it's
just how Excel does it. If you google "print several pages as one job"
there's a discussion that seems to confirm this.

hth,

Doug

"Yoam69" wrote in message
...
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.