VBA Code to create a single PDF from multiple worksheets

Hi Guys,

I'm pretty new here, but I have already found some great macros, but I need a bit of help with this one.

I need a macro to create a single PDF based on the print area of 5 different worksheets. I want the filename to be a cell in another sheet (Eg A1 in a sheet called 'Set"), and I also want to be able to save it to a directory eg C:\PDF

Any help would be appreciated.

Below is a macro I found and have tried to manipulate to make it do what I want it to do....but without any success so far...it gets stuck on the 'nname' line.

Please Login or Register  to view this content.

Cool.....one more thing.
Can I reference the path to a cell in my 'Setup' sheet...eg B8 rather than hard referencing it in the macro?

Thanks, this has been a great help!!