or did you mean you wanted to completely remove the autofilter? (so that the
drop-down boxes are no longer there)?


"Jasmine" wrote:

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!