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 slicer. The error I got is Run-time error '5': Invalid procedure call or argument
And the code highlighted in yellow when Debug is
Below is my full code. Any help is hugely appreciated!Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks