Macro to Save to a PDF, using the contents of a cell as the filename

[micwes27]

Hi,
I have been trying to create a Macro that save the current sheet to a pdf file in a specific directory.
It all works fine if you specify the "Filename" in the macro, but I have a particular cell that always has a different content based on selections made and it is the content of this cell that I want as the "Filename" that is saved
Has anybody done this?

[benishiryo]

hi micwes27, welcome to the forum. just try recording the macro of saving as a PDF & you should get something like this:

Please Login or Register  to view this content.

break up the red coloured portion as the cell where you have the filename. for eg, mine is in A1:

Please Login or Register  to view this content.

[andy1883]

Hi thanks for the code this works fine, but i would like it to save two cells, is this possible?