Issue saving Excel Worksheet to .pdf

[Aussiebear]

Welcome to VBAX kpost. Someone will be along shortly to assist you in this matter.

In the mean time this is how I would save a workbook as a pdf file

Sub SaveActiveWorkbookAsPDF()
    ' Create and assign variables
    Dim saveLocation As String
    saveLocation = "C:\Users\JimmyCrickets\Documents\myPDFFile.pdf"
    ' Save active workbook as PDF
    ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:=saveLocation
End Sub