First post.
I have a 3 sheet Excel spreadsheet and would like to print each worksheet to a separate pdf file from within a macro, using the worksheet name as the pdf output file name in each case i.e. sheet1.pdf, sheet2.pdf, sheet3.pdf. Thanks for any ideas, as I've failed with everything I've tried so far.
print using worksheet name from excel macro
Moderator: jr