Hello,
I've got a issue with my Macros in Excel in my PC only.
It worked just fine before and it still works on another pc with both Win 7 & Win 10, however it does not on my PC.
I have done clean installation of Win 10, at start it works fine. After few days and recent Windows update it again started throwing an error.
When I try to run excel with macro "ExportAsFixedFormat xlTypePDF", it throws an error and highlights this area when I press Debug: as shown in images.
The error thrown line is as below
Range("A1:I48").ExportAsFixedFormat xlTypePDF, Environ("Userprofile") & "\Desktop\PrintPDF.pdf"
here I am trying to export a certain range in PDF format.
Kindly Help. As I cannot clean install again and again.