larissalle
Technical User
I know how to test if activesheet.autofiltermode = true. Can I do something similar to test if there are any hidden columns in a worksheet? If true, I want to unhide them. If false, do nothing.
The following didn't work:
first select worksheet, then
If Selection.EntireColumn.Hidden = True then
Cells.Select
Selection.EntireColumn.Hidden = False
End If
The following didn't work:
first select worksheet, then
If Selection.EntireColumn.Hidden = True then
Cells.Select
Selection.EntireColumn.Hidden = False
End If