Print used range to PDF

[rob_h]

I thought I had this worked out, but as it turns out, not really

The intent of the "Print to PDF" button on the worksheet is to print only a used range of cells, in this case A1:G4. The list is dynamic such that several more rows of data could be used below row 4.

So, what I'm trying to do is print only the used range of A1 to ? based on the used rows of A:G

As always, thank you for any assistance.

[Dante Amor]

Try this:

Please Login or Register  to view this content.

[rob_h]

That code looks much cleaner, but I still get a run time error "Document not saved. The document may be open, or an error may have been encountered when saving"

Does a Save command need to be entered somewhere in the code?

Thank You

[Dante Amor]

I have no problem saving as pdf.
Try this version:

Please Login or Register  to view this content.