Hi There!
I am having an error trying to save to PDF as the code cycles through the Slicer. I borrowed this code from a 4 year old thread on the site: 1184223-macro-for-looping-through-slicer-and-saving-as-pdf-writing-over-same-pdf.html - sorry I can't post a link yet!
But it continues to break at the PDF section. When I remove it, I can see that it is cycling through the slicer. I am not super well versed in VBA's, but have successfully used VBA's that cycle through dropdown menus and save to PDF. I am getting run-time error code 5 - invalid procedure call or argument
Any help would be appreciated! Thank you in advance!
Also I am referencing cell D1 - as a cell that is referencing the Pivot Table's cell from another sheet - please let me know if that is wrong
Bookmarks