mfleuette1
New Member
- Joined
- Jul 1, 2013
- Messages
- 4
Hi - first post here in a long time, and could not find a related topic thru search. The problem I am trying to solve is turning off all filters on a table of data returned by MS Query (many columns, one or more of which may have a filter). However, ActiveWorksheet.AutoFilterMode and Active WorkSheet.FilterMode both return FALSE, even though the query is returned with filters and I have filtered one or more columns. How can I turn off active filters on the rows returned by the query (e.g. ShowAllData), without removing all filters? (AND ON A SIDE NOTE - how do you punctuate a forum post - carriage returns, etc.?)