LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
cannot use "Create List" and "Share Workbook" same time Devendra Excel Discussion (Misc queries) 0 October 26th 06 06:05 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM
How do I get rid of "Top 10" and "Custom" choices Autofilter? JosiePosie21 Excel Worksheet Functions 2 March 17th 06 07:30 PM


All times are GMT +1. The time now is 01:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"