
How to save each Worksheet as a single PDF?
The below code will let you save each Worksheet as a single PDF Sub SaveWorkshetAsPDF() Dimws As Worksheet For Each ws In Worksheetsws.ExportAsFixedFormat xlTypePDF, “ENTER FOLDER NAME HERE” ; ws.Name… Read more »