Save as .PDF not working

I am trying to save my current work sheet as a PDF file. It seems to work until I go to open the file through "Adobe Reader".
That's when I get the following error


"The document is damaged and cannot be repaired. Adobe Reader could not open because it is either not a supported file type or because the file has been damaged (for example, it was sent as an email attachment and wasn't correctly decoded)."

Here is my code

Please Login or Register  to view this content.

Have I missed something?

Use the macro recorder then change the code as you want

Hi, Wouldsman,

indeed a you canīt save directly using SaveAs but would need to use ExportAsFixedFormat:

Please Login or Register  to view this content.

Ciao,
Holger