VBA loop through slicer and export multiple sheets to PDF

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

Please Login or Register  to view this content.

Below is my full code. Any help is hugely appreciated!

Please Login or Register  to view this content.

Please read Forum Rules point 3.

Cross-post here: https://www.mrexcel.com/board/thread...o-pdf.1189203/