Hi all, I have a macro to print to PDF. Problem I am having is when I run it, it changes my margins and prints across multiple pages instead of the margins I set. Here is the code I am using:
Sub Export_to_pdf()
ChDir "/Users/name/Desktop/"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _
"/Users/name/Desktop/" & Cells(1, 1).Value, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
True
End Sub
Is there anything I can add or change so this doesn't happen?
Thanks!
Bookmarks