Excel print multiple worksheets as one document
Posted on 2011-09-19
I'm trying to write a macro that exports my excel document to pdf. I can do this one worksheet at a time but i wish to export specific worksheets (dependent on a table of contents) all into the one pdf file.
For example, say i have worksheets A - F, and this time round i want A,B,D and E all to be exported to the one pdf file.