I am impressed with the code
http://spreadsheetpage.com/index.php...eets_to_print/
this enables to print selected pages using default printer.
I need few changes.
I want a macro to save selected worksheets from active workbook as PDF. also want Sheet 5 and Sheet 6 seven times each on same PDF file.
Appreciate your efforts in helping me solve the challenge.
http://spreadsheetpage.com/index.php...eets_to_print/
this enables to print selected pages using default printer.
I need few changes.
I want a macro to save selected worksheets from active workbook as PDF. also want Sheet 5 and Sheet 6 seven times each on same PDF file.
Appreciate your efforts in helping me solve the challenge.