I have a macro that is supposed to unhide all columns and unfilter rows, but the unfilter portion doesn't work.
I would like the macro to unfilter the spreadsheet if a filter is applied and to not return an error if there is no filter applied. I read that AutoFilter needs to be turned on for ShowAllData to work so I attempted to do that. Still not working.
Cells.EntireColumn.Hidden = False
Cells.EntireRow.Hidden = False
If ActiveSheet.AutoFilterMode = False Then