Oct 28, 2017 · It is possible to loop through each worksheet in the active workbook and save each into its own PDF. 'Loop through all worksheets and save as individual PDF in same folder 'as the Excel file Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.ExportAsFixedFormat Type:=xlTypePDF, Filename:=ws.Name Next Other PDF Export Options

Jul 31, 2019 · Note that this macro will only display worksheet names; it will not display the names of other types of sheets in the workbook. You can also loop through all of the worksheets in the workbook by using a 'For Each' loop. Enter the following macro code into a new module sheet. Loop is commonly used in all of the programming languages, where there is a certain need or a criteria when we need a certain code to run a certain times we use loops for those codes, now there are many types of loops in VBA such as Do while, Do until, For Loop and For each loop, these loops help code to execute until the condition is met. How to Transfer Specific Data from One Sheet to another through VBA in Microsoft Excel In this article, we will use change event of worksheet to transfer data one sheet to another, depending upon a certain condition.