Range("$A$1").AutoFilter Field:=1, Visibledropdown:=False
https://youtu.be/E6Nj2vIvlpI
http://www.xlorate.com/excel-questio...s%20you%20Type

These example show how to hide the filter arrow