Autofilter Arrows showing

[pincivma]

Hi there
I have done a macro that filters the whole worksheet. Then I did another macro that unfilters it.

The code "Selection.Autofilter" Unfilters the worksheet. But I want to get rid of those pesky dropdown arrows every time I run the code. I tried the following code, but I got an error.

Selection.AutoFilter , VisibleDropDown:=False

 

[Michael M]

try using for say, column "A"

Selection.AutoFilter Field:=1, VisibleDropDown:=False

 

[pincivma]

OK Thanks for the code.