How to save each worksheet as a separate PDF
In this tutorial you will learn how to save each worksheet as a separate PDF file using VBA macro programming in Microsoft Excel
VBA Code:
'This code will save each worsheet as a separate PDF
Sub SaveEachAsPDF()
Dim ws As Worksheet
For Each ws In Worksheets
ws.ExportAsFixedFormat xlTypePDF, "D:\demo\" & ws.Name & ".pdf"
Next ws
MsgBox ("Worksheets are successfully saved")
End Sub
play_arrow
How to find duplicate values from data in excel before removing them | Learn in 5 Minutes
play_arrow
How to use Nested Xlookup to build two-way lookup in Microsoft Excel | Learn in 5 Minutes