I have about 40 sheets that I want to access and print, as well as save, but within each sheet I want only specific pages printed and saved. How can I alter my code to make that happen?
You guys rock,![]()
Sub ZA_print() Sheets("Zone A").Select ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, fileName:="s:\Communities\Monthly\Zone A\Zone A.pdf", Quality:=xlQualityStandard, IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:=False
Thanks
Bookmarks