Printing of non-sequential pages
 

create a small macro with the following lines (test on XP)

ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1, Copies:=1,
Collate:=True
ActiveWindow.SelectedSheets.PrintOut From:=5, To:=5, Copies:=1,
Collate:=True

Guido

http://hologuides.com/programming/ExcelVBA


"RC" schrieb im Newsbeitrag
...
Does anyone know how to print non-sequential pages at one
time? Say, print only pages 1,5,8,11,17 only. I have a
long and wide spreedsheet but I need to print some of them
at one time only. I have sick of sending the job per
page. Please kindly help. Thanks a lot.

RC