Identify hidden rows when using a slicer

[gheyman]

Is there a way to identify which rows are hidden (or not hidden) when using a slicer? What I am trying to do is get around Subtotal type formulas. So if I could put an "X", for example, in columns that are hidden when a slicer is used then I have a way with either formulas or VBA to do things with just the unhidden rows.

my table name is MT_MAH_Flex and the specific slicer/column I am interested in is the "TASK ID" (or any other slicer is possible).

Thanks.

PS It would be helpful to clear the marker when the slicer is unfiltered/cleared as well.

 

[RoryA]

I don't follow. Slicers don't hide columns, and if you are just trying to work with visible cells in VBA then that is one of the things the SpecialCells method is for.

 

[gheyman]

Correct, Rory. I should have said "So if I could put an "X", for example, in rows that are hidden....

 

[RoryA]

As I said, in VBA you don't need to. With formulas, using a helper column with a SUBTOTAL/AGGREGATE formula is probably most efficient, or you could use that in something like a MAP function.