Hi all

I currently have the following macro working within my workbook;

Sub exportPDF()
fName = Application.GetSaveAsFilename("", "PDF Files (*.pdf), *.pdf")
ActiveSheet.ExportAsFixedFormat xlTypePDF, fName, xlQualityStandard, , , , , True
End Sub

which works great however, i would like it to print & compile 2 pages (i.e. tabs 1 & 3) from the workbook. Im sure this is fairly simple however, i cant figure it out!

cheers