run-time error '5'

I have an excel file containing multiple charts showing sales, demand, etc. in 5 sheets. These charts are linked and filtered by a slicer "Product Name". This slicer is located in sheet "Supplier". I am trying to export these 5 sheets to PDF per product by having the code to loop through...

I am trying to get a set of Excel files that are unique by campaign type with pivot tables for geographic regions in separate worksheets to instead be pasted values for each campaign type in separate worksheets in unique geographic region Excel files. I first change the .xlsx files to instead be...

I wrote a VBA macro that generates, saves, and opens a PDF of an array of sheets from an Excel workbook. The macro works for most users in my organization, but a few users have reported receiving an error message that states, "Run-time error '5': Invalid procedure call or argument." All...

I pretty much changed few variable names from my old code. and i got "Run-time error '5': Invalid Procedure call or argument" Im very new to this website, so please help me. I dont even kno how to make that Code box. Thanks in advance...