View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] brad...man@gmail.com is offline
external usenet poster
 
Posts: 1
Default List AutoFilter Changes to "All"

Running WinXP and Excel2003 with all updates.
I have an odd problem that I'm having difficulty debugging. I have a
List (as in from the DataList menu) that I generate from code. I
often have the AutoFilters set so that the 100+ rows on the list are
only displaying the five or so rows that I need to get data from. The
problem that I'm having is that sometimes (at this point it seems
completely random) the list will expand and all the AutoFilters go to
"(All)" so that my 100+ rows are showing again. This event will
happen after I click inside the List, or in other words, "activate"
the list. If I choose "Undo - List Activate" from the undo menu, the
list will go back to the filtered state and the problem WILL NOT re-
occur. Unfortunately I do not know what will reproduce the behavior,
that is what is making this so hard to debug, but the List is
generated from my code, so I believe I may be doing something to cause
this result.

I was just wondering if anyone has ever experienced something similar.