View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tigerxxx Tigerxxx is offline
external usenet poster
 
Posts: 78
Default Print selected pages from multiple worksheets

When I go to file print, I can select different pages from one worksheet but
how can I select different pages from different worksheets in the same
workbook?
Example-
I have 5 worksheets in a workbook. Each worksheet has 10 pages configured
for printing.
How can I select-
Page 1 & 7 from worksheet 1
Pages 2 & 5 from worksheet 3
Pages 4 & 9 from worksheet 5
....all to print at once?

Thank you