using autofilter in excel and feature locks up
 

Why would a filtered spreadsheet not unfilter?

using autofilter in excel and feature locks up
 

Hi

I get this sometimes and I have found no way to avoid it. What is
annoying is that the standard filter button thru Excel does not remove
autofilter (it just turns autofilter on) which means you have a two
stage process of DataAutofilter to turn it off. Also, I often end up
with hidden rows doing it this way, so then need to unhide those.

The most practical solution I came up with was placing a custom button
on one of my menu bars and assigning a subroutine to it which was:

Sub TurnOffAutofilter()
ActiveCell.EntireRow.AutoFilter
With Cells
.EntireColumn.Hidden = False
.EntireRow.Hidden = False
End With
End Sub

This can be modified to match your specific needs if required.

Richard
wrote:

Why would a filtered spreadsheet not unfilter?