Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
How do I get rid of "Top 10" and "Custom" choices Autofilter? | Excel Worksheet Functions |