Macro to export to PDF but also re arrange the tab order

Hi everyone,

I found a useful thread on here that shows how to export to PDF and it works well, but when I export 7 tabs to a PDF, the order of the PDF pages isn't ideal. I imagine I could change the order a few different ways, such as writing code to copy the excel file, then rearrange the tabs, then save as PDF and finally close the copy without saving. Do you think this would be a good approach? How would you write this type of macro? Let's call the 7 tabs: Summary, Summary 2, Summary 3....Summary 7

Thanks

It sounds like this is not what you want although the Sheets in your Post are in sequence.

Please Login or Register  to view this content.

Ah yes, but the order would need to be Summary 7, Summary 6..etc

I tried re ordering the array and it didn't work, I think I would have to use the Move.Sheet method

Thank you

If the sheets to be printed are not in sequence in your workbook, try this.
Put the sheets to be printed in shArr2 in order you want them printed to PDF

Please Login or Register  to view this content.

This worked.

The order of the Array didn't result in the same order for the PDF - For some reason PDF page 1 was array Summary spot 3, but I just changed the summary page order in the array to conform to what I was seeing in the end result and this code works perfectly.

Thank you

If you're happy with it, that's all that counts
Good luck