Send Sheets to PDF in Specific Order

Good Morning,

I was wondering if anyone knew of a way to send select sheets to PDF but in a specific order. I do not want to reorganize the order of the workbook so it jumps around a bit and when I use the Sheets(array()) it does not return what I am looking for. Any help you can provide would be greatly appreciated.

Hi HP25,

If you can't find another way to do it, you can create the pdf file and then reorder the pdf file pages later.

See the download file associated with post #4 of the following thread, which reorders pages in a pdf file.
http://www.excelforum.com/excel-prog...reposting.html

It uses a program called 'PDFtf' (PDF Took Kit). The FREE version should do what you want.
http://www.pdflabs.com/tools/pdftk-the-pdf-toolkit/

Lewis