Presently using the following code:
Code
Sub PDF_laptop()
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Users\cyril\Desktop\" & Range("x1").Value, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
False
End Sub
The above works with a Set Print Area however I would like to add one VBA to export as PDF the range such as ("AD16:AT71")
same filename, same quality...
Thank you for any advice.