To export a sheet as a PDF using VBA, you can use the `ExportAsFixedFormat` method, which is part of the `Worksheet` or `Workbook` object. Below is an example of how you can use VBA to export an active worksheet to a PDF file:

Sub ExportSheetAsPDF()
    Dim ws As Worksheet
    Dim pdfFilePath As String

    ' Set the worksheet you want to export
    Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to the name of your sheet

    ' Define the file path and name for the PDF
    pdfFilePath = ThisWorkbook.Path & "" & ws.Name & "".pdf"" ' Saves in the same folder as the workbook

• Open Excel and press `Alt + F11` to open the VBA editor.
• Go to `Insert > Module` to create a new module.
• Copy and paste the following VBA code into the module:

Follow us on Social Media

facebooklinkedin

Unlock Your Potential

Excel

Access

Power BI

Help us grow the project