AutoFilterMode not working for table returned by query

[mfleuette1]

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.?)

 

[RoryA]

Assuming a version of Excel later than 2003 you probably have a Listobject in which case:

Activesheet.Listobjects(1).Autofilter.ShowAllData

for example.

 

[Andrew Poulsom]

Is you query returning a ListObject?

Excel Filters -- Excel List AutoFilter VBA

 

[mfleuette1]

Assuming a version of Excel later than 2003 you probably have a Listobject in which case:

Activesheet.Listobjects(1).Autofilter.ShowAllData

for example.

BRILLIANT! Thank you - that is exactly the fix I wanted