to answer your specific Question:
Dim w as Worksheet, f as Filter
Set w = Activesheet
For Each f In w.AutoFilter.Filters
If f.On Then
End if
Next
Look at the object browser for the filter object to see properties.
--
Regards,
Tom Ogilvy
"lcoreyl" wrote in message
...
I am wanting to know if there is code that can look to see if any fields
within autofilter are currently filtering. I would like to have code
that is dependent on whether or not this is true.
I currently have to just tell every field to stop filtering even if
they're not and this takes a long time and needlessly a lot of the
time
Thanks
--
lcoreyl
------------------------------------------------------------------------
lcoreyl's Profile:
http://www.excelforum.com/member.php...fo&userid=2042
View this thread: http://www.excelforum.com/showthread...hreadid=262326