If ActiveSheet.AutofilterMode then activesheet.usedrange.autofilter

Robert Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel


"scrabtree" wrote in message
...
I have a hidden sheet and depending on the order of when
other macros have been ran, the sheet may or may not be
autofiltered. I need a code that will look at the hidden
sheet and turn off the autofilter if it is on and not do
anything if it is not.