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:
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!
Bookmarks