Is it possible to specify a "print area" for the PDF ExportasFixedFormat functionality in Excel
In the code below, I wanted to export the contents of the sheet "Confirmations" but the contents
of the first sheet are being published instead.
Perhaps it may be handiest to export the contents of the sheet to
a new temporary workbook and export from that?
Thanks in advance for any advice
' SaveTC2PDF Macro
Dim PDFFilename As String
PDFFilename = "c:DRDOperationsManagementSystemTrainerConfirmationPDFs" _
& .Range("j1").Text & _
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _