Export multiple pages and ranges to PDF

I am trying to Export 4 sheets to 1 PDF however i only want selected data on each sheet.

I have tried copying everything into one sheet however they have different column widths so this is not a viable option.

I have also tried the following code that works to a point...

On selecting all the sheets it appears to use the range on the last selected sheet for all 4 selected sheets rather than adhering to the previously selected ranges. this causes an issue due to one of the sheets potentially needing more than 1 page depending on the data shown in a pivot table.

I am unable to share the file due to the nature of its contents however i have shared the VBA code i have so far below.

Any help will be appreciated

Please Login or Register  to view this content.

I have managed to do it myself, in stead of deleting the post i thought i would post my fix just in case it helps anybody else in the future.

There may well be a better way of doing it, and please correct it if this is the case however this is what i finally came up with

Please Login or Register  to view this content.