Selecting filters

[Mangolili]

Is there a VBA version that does this? I want to select a filter from a column,
ran the macro, then delete the previous filter that's selected. Select a new filter from another
column, ran the macro again.

Is there any way to do it? Please let me know. Thanks



""" Handles the user clicking the **Delete** button. """ # Get the list of available filters: filters = info.filter.factory.values if info.initialized: # Delete the current filter: index = filters.index( self.filter ) del filters[ index ] # Select a new filter: if index >= len( filters ): index -= 1 self.filter = filters[ index ] self._refresh_filters( info )</pre>

 

[venkat1926]

for example the data range is defined by "r"
r.autfilter.........................
will filter the data.

after doing whatever to be done wit the filtered data you write again
r.autifilter
the filter is removed.

another way for removing the filter if the sheet is activated
activesheet.autofiltermode=false