0
down vote
favorite
I have a worksheet in Excel with several pages. I want to print selected pages, e.G. Page 1, Page 3, Page 4 and Page 6. Can I do this in a singel print job?

In know i can print the pages with the commands: ActiveSheet.PrintOut From:=1, To:=1, Copies:=1, Collate:=True
ActiveSheet.PrintOut From:=1, To:=3, Copies:=3, Collate:=True
ActiveSheet.PrintOut From:=1, To:=4, Copies:=4, Collate:=True
ActiveSheet.PrintOut From:=1, To:=6, Copies:=6, Collate:=True

But this way, i create a lot of print jobs. Therefore i look like something like PrintOut(Page1, Page 3, Page 4, ....)




More Information about my Problem: There are a delivery notes in my Worksheets: Excel delivery notes Some of them dont have entries in the C-column. (for example Page 2). I wrote a Makro which iterates over the pagebreakes and check the C-column on every page:

Please Login or Register  to view this content.
But this macro sent a printjob for each page. How can i print the relevant pages by sending only one printjob?

Thanks for your help!