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.

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.

Slightly different:

If worksheets("hiddensheetname").AutofilterMode then _
worksheets("hiddensheetname").AutofilterMode = False

--
Regards,
Tom Ogilvy


"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.

and I add an other detail:
(if you do not want the whole used range to be autofiltered)


with range("A1:A10") ' put here the head of wanted colmuns

' this deactivate it if already used ANYWHERE ON THIS SHEET:
If .AutoFilter Then: .AutoFilter ' (when no arguments, just toggle)

' this activate it on the right cells:
..AutoFilter 1, , , , True

end with