In Excel VBA is it possible to differentiate between filtered hidden rows and manually hidden cells?

Asked Sep 22 '16 at 15:11

Active Sep 22 '16 at 15:11

Viewed 237 times

I would like to write some VBA code that unhides all rows that have been hidden with a macro (Rows.Hidden = True), but which leaves rows hidden by filters alone. Is this possible? I can't find a way to differentiate between the two.

Thanks in advance

edited Jul 09 '18 at 19:34

Community

asked Sep 22 '16 at 15:11

kwibbler

3

Un-hide all then reapply the filter. – Scott Craner Sep 22 '16 at 15:12
Can the filter be reapplied in code? – kwibbler Sep 22 '16 at 16:18
http://stackoverflow.com/questions/9489126/in-excel-vba-how-do-i-save-restore-a-user-defined-filter – Tim Williams Sep 22 '16 at 16:35
Found this for reapply filter: – kwibbler Sep 22 '16 at 16:59
ActiveSheet.AutoFilter.ApplyFilter. Seems to be working fine, thank you for the help! – kwibbler Sep 22 '16 at 17:01

In Excel VBA is it possible to differentiate between filtered hidden rows and manually hidden cells?

0 Answers0