Save PDF to users desktop and use value of specific cell in part of the name

Good Day!

In advance my apologies, I'm sure this is a very simple question. Unfortunately I don't understand much of VBA and usually manage to piece the macros that I need together with the power of google or recording a macro. In this particular case I am stuck and I'm hoping somebody can help me.

So I have an excel file with several tabs, which I want to save as a PDF on the users desktop. This macro works like a charm :

Please Login or Register  to view this content.

It saves all the sheets that I want onto my desktop as "myfilename.pdf".

What i would like it to do is replace "myfilename" with the value of Title!C13 instead. I believe the correct reference looks like this

Please Login or Register  to view this content.

But I can't figure out how to tie it into this line

Please Login or Register  to view this content.

I would much appreciate help with this!

Thanks

Maike

Likely something like:

Please Login or Register  to view this content.

You could also save the value of the cell into a variable and use the variable in place of the "Worksheets("Title").Range("C13").Value" above.

Originally Posted by Zer0Cool

Likely something like:

Please Login or Register  to view this content.

You could also save the value of the cell into a variable and use the variable in place of the "Worksheets("Title").Range("C13").Value" above.

I tried that and it errored out. Must've missed a quote or space or something somewhere.. Thank you Zer0