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.

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.

ufo_pilot wrote:

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.

--

Dave Peterson

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

"Dave Peterson" wrote:

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.

ufo_pilot wrote:

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.

--

Dave Peterson