Good Morning Folks!
I am trying to converts several worksheets into a .pdf document and have spent a few hours surfing and have come up with this so far:
Sub PDFPrintNSave()
Application.ScreenUpdating = False
'Sheets(Array("Sheet 1", "Sheet 2")).Sheet1 , , 1
Sheet1.ExportAsFixedFormat Type:=x1TypePDF, Filename:="C:\PDF\1on1.pdf", OpenAfterPublish:=True
Application.ScreenUpdating = True
End Sub
The problem I can't seem to get past is in the second line (bold and Red). I cannot figure out what should be input here to make the array work. Any ideas?

I am trying to converts several worksheets into a .pdf document and have spent a few hours surfing and have come up with this so far:
Sub PDFPrintNSave()
Application.ScreenUpdating = False
'Sheets(Array("Sheet 1", "Sheet 2")).Sheet1 , , 1
Sheet1.ExportAsFixedFormat Type:=x1TypePDF, Filename:="C:\PDF\1on1.pdf", OpenAfterPublish:=True
Application.ScreenUpdating = True
End Sub
The problem I can't seem to get past is in the second line (bold and Red). I cannot figure out what should be input here to make the array work. Any ideas?