Save, Print, and Delete on Command

.
Take note that nothing in your written description above matches the attached workbook (rows, columns, named cell range).
You'll need to correct before a reasonable answer can be given.

I switched the word row for column in the first line, everything else matches. Fixed my mistake, thank you.

.
PRINT AREA is considered everything above the work PRINT but not the Column Header ?

Oh weird, my Print_Area didn't stick. Print_Area would just be Sheet1!R1C1:R11C2

.
Ok .. and hopefully lastly ... what is "delete the named cell range, "Worksheet" ?

Check the name manager, that cell range is in there. It's basically everything except the headers.

.
Sorry. Your downloaded example does not show "Worksheet".

In any case, paste this macro in the Sheet2 module :

Please Login or Register  to view this content.

Paste the following in a Regular Module :

Please Login or Register  to view this content.

In the regular module, change "gagli" (located in the path), to the name of your computer.

The macros save the range to the Desktop as a PDF. You can print it from there.

I can work with this, thank you! As it stands, it names the pdf with just the date. How can I add to that title?

.

Please Login or Register  to view this content.

Hmm, I entered that in and updated the filepath and it gives me a runtime error and "Document not saved." Debugger then highlights the whole thing.

.
Post your code.

Please Login or Register  to view this content.

.
I changed your computer name GW23140 for mine and successfullly ran the macro here.

The name of your computer that you are using must be the cause of the error.