Removing blanks from pivot table slivers within a macro

I created a macro to create the beginning of a pivot table- just the rows and slicers, because when I tried making a longer macro to create the entire pivot table (formatting, etc) I couldn't get the macro to work.

So I do get all the vertical rows I want, and I do get all the slicers I want. But I get blank space. I think this is because the pivot table is created from another tab, and the length of data in that tab will vary from file to file (I'm doing another 30 or so of these, all with varying amounts of data, but the same data categories).

Anyway, I get slicers, but in addition to getting the categories I want, I also get "(blank)" below the names in the slicers. Is there a way to add some code to the macro to remove the blanks so I don't get this field?

I have copied and pasted the macro below, with identifying data changed.

Please Login or Register  to view this content.

It is not possible to remove items from slicer but you may try to change this line:

Please Login or Register  to view this content.

to this code:

Please Login or Register  to view this content.

This will allow the pivot table to only use the actual data range.

You are welcome.

Please remember to mark thread solved using Thread Tools link at top of this page.