Autofilter, terminates after selecting "ALL"

U

ufo_pilot

I first filter through the data via "ends with"
this works fine, then I want to go back to "ALL" through the autofilter and
it shuts me down every time. I get this message:
Instructions @ 0x302726d reference memory at 0x2f840006. The memory could
not be "read"
I have no clue what it could be.
Any insight is greatly appreciated.
 
D

Dave Peterson

Something bad is happening.

My first guess is that the workbook or worksheet is getting corrupted.

I'd create the same table on a new worksheet (in a new workbook???) and try it
there. If it works ok, then delete the old workbook and keep the new workbook.
 
U

ufo_pilot

Thanks Dave
For now I select the "NonBlanks" in the filter to get back to all the data.
I will try your suggestion next
 
Top