Excel Slicer Loop VBA

Question

I am using Excel 2010.  My problem is this:  

• I have slicer that is connected to 3 sheets.
• I would like to click on a slicer called a Dept and save the 3 sheets as a filename .pdf.

I recorded a macro that worked perfectly, the problem I am having is this when I run the macro a week after, I get this:

 #GETTING_DATA #GETTING_DATA #GETTING_DATA 0.00% #GETTING_DATA .  

My hunch is either I do not have a line in my VBA to take care of slicers that do not have data or I need some kind of a code to loop and clear the slicer cache anytime a I click on a slicer value.   By the way the first report with data runs perfectly.

Below is the code I am using.

Sub MonthlyPDFs()

'

' MonthlyPDFs Macro

'

'

Sheets("PIVOT_cube").Selec

ActiveWorkbook.SlicerCache

Thanks

Answer 1

Please abandon the question.

Thanks