I had a similar problem a few months ago. I surmised that Excel uses
an internal counter to track shapes. Each time that you AutoFilter,
this counter ratchets up until it hits approximately 65,500, whereupon
an out-of-bounds error occurs.

To test my theory, I created a new workbook with junk data. After each
Autofiltering, I ran a subroutine that checked the numbering
(counting) of the AutoFilter shapes. It was ratcheting upwards.

I've also had problems with other workbooks that use a lot of
filtering. The only solution I could come up with was to recreate the
workbooks .

Below is the thread that tells part of the story.

http://groups-beta.google.com/group/...e8b8e13f31bd4?

HTH
Paul

------------------------------------------------------------------------------------------------

On Thu, 7 Jul 2005 09:37:35 -0700, "Kile"
wrote:

I have a Inventory spreadsheet with filters. I have used it for a couple of
years now with no problems. Now every time i use a filter it freezes Excel
and I have to close it and lose any changes. Is there anything I can do to
fix this?