Print out certain pages in an excel sheet by PrintOut Method

Originally Posted by bhayu

Dear tanvi_kalra,

Thanks for replying. Your answer may apply to other condition, yet it hasnt answered my question.

What if I have to print out 50 certain/selected pages of 100 pages available in sheet1?

Any shortest script possible to write instead of writing "Worksheets("Sheet1").PrintOut From:= , To:= " for 50 times?

Thanks in advance.

For that you can use loop for the shortest code .. i didn't get your question clearly. Could you please clarify it again.
Are you trying to printout many sheets from one tab only or from different tabs or both. please elaborate.