It sounds like you might be deleting shapes and somehow your method of
determining which ones to delete has gotten out of kilter.

If this sounds likely, then you might want to look at that code.

The dropdown arrows in the Autofilter are part of the shapes collection.

Also, if you are adding controls, perhaps the default names are causing
duplicates, or has gotten too high.

--
Regards,
Tom Ogilvy


"CLR" wrote:

Hi All.......

I have a 4 meg Excel program that uses the AutoFilter extensively throughout
it's macros, and has been working fine for several years. Now, all of a
sudden, if I cycle the AutoFilter on and off, two times.....it causes some
sort of corruption. Several of the AutoFilter drop down arrows do not
dissappear the second time around, yet are unfunctional. Also, several of my
drawing rectangles that I use to trigger other macros just dissappear! It
does this no matter how I cycle the AutoFilter, by macro or even if I do the
regular Data Filter AutoFilter sequence by hand. There are no
ChangeEvent macros.....at least not any that I put in, nor can see. Could
someone have installed a "hidden" macro that I don't know where it might
be?.....could this be a virus?

Anybody ever heard of this, or have any ideas?

TIA
Vaya con Dios,
Chuck, CABGx3