Dave & Tom - would that reset them all to show 'all' items in the column, or
remove the autofilter from the sheet?

thx!

J

"Tom Ogilvy" wrote:

Activesheet.AutoFilterMode = False

works whether there is an autofilter on the sheet or not.

--
Regards,
Tom Ogilvy

"Jasmine" wrote in message
...
I actually mean the the drop-down arrows for the filters are on and I need
them to be off.

"Gixxer_J_97" wrote:

if you mean having each filter set to show 'all' then something like
this
might help

With Sheets("MySheet")
For i = 1 To Sheets("MySheet").UsedRange.Columns.count '- 1
.Rows(1).AutoFilter field:=i
Next i
End With

change the argument of .Rows() to match what row your filters are in


"Jasmine" wrote:

I have a worksheet that may or may not have the AutoFilters turned on.
I need
to have the filters off before I run the macro I have written. How can
I
incorporate this into my macro? Thanks!