I have the below macro that prints a chart fine but I am curios if there is a way to reference to a cell on a different sheet not included in the print request for the file name ? Thanks in Advance Gerry.
(Title!$AA$5) file name location Sheet name is Title
Sub SaveREPORTEWToPDF()
Dim OriginalSheet As String
OriginalSheet = ActiveSheet.Name
Sheets(Array("E-W Plan")).Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=ThisWorkbook.Path & "\EW Planview.pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True
End Sub
(Title!$AA$5) file name location Sheet name is Title
Sub SaveREPORTEWToPDF()
Dim OriginalSheet As String
OriginalSheet = ActiveSheet.Name
Sheets(Array("E-W Plan")).Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=ThisWorkbook.Path & "\EW Planview.pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True
End Sub