Autofilter Arrows showing

pincivma

Board Regular
Joined
Dec 12, 2004
Messages
199
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
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,237
Office Version
  1. 2013
Platform
  1. Windows
try using for say, column "A"
Code:
Selection.AutoFilter Field:=1, VisibleDropDown:=False
 

Watch MrExcel Video

Forum statistics

Threads
1,108,612
Messages
5,523,891
Members
409,542
Latest member
Shezz01

This Week's Hot Topics

Top