In using a macro to print to a PDF, can I use more that one cell for my "pdfname=" ie.: pdfname = Range ("A2:A3") . Text ? My macro works with one cell, but does not work with two cells.
This is my macro:
Sub Print_PDF()
Range("Print_Area").Select
pdfname = Range("A2").Text
ActiveSheet.ExportAsFixedFormat Type:=xlsxTypePDF, Filename:="C:\Users\Bar\Documents\Steph\Pay\" + pdfname + ".pdf" _
, IgnorePrintAreas:=False, OpenAfterPublish:=False
End Sub