Rows hidden by Autofilter vs hidden by changing the Hidden property

Rows hidden by Autofilter vs hidden by changing the Hidden property

Post by LE » Tue, 11 Sep 2007 23:38:09


Hi, does anyone know how to determine if a Row is currently hidden by an
autofilter? If a row is hidden (by an autofilter or by changing the
EntireRow.Hidden property to True), the Hidden property of the EntireRow
returns True. Therefore the Hidden property cannot be used to determine if
the row has been hidden by an autofilter or not.

If a row is hidden by criteria of an AutoFilter, it does not function as
when hidden in other ways. This example demonstrates this:
An autofilter has a criteria applied- rows 3 and 4 are hidden as a result.
If you select Rows 2 to 5 and apply a specific formatting, the formatting
only is applied to the visible rows, i.e. 2 and 5, not 3 and 4.
If, on the other hand, you do Rows("3:4").hidden = true, then select Rows 2
to 5 and apply a specific formatting, the formatting is applied to both
visible and hidden rows, i.e. 2 to 5.

Is there a property that can tell me this "hidden level"?

Thank you very much.

Leo