Re : Excel to Insert an AutoFilter (at will)

[tkt_tang]

1. Enters an Excel WorkSheet.

2. Apply an AutoFilter in Column A. It's done. Easy.

3. Apply an AutoFilter in Column C. It can't be done until Column B is
also AutoFilter'd.

4. You see, Column B is reserved blank to serve as a divider between
Columns A and C.

5. Really don't wanna see an AutoFilter arrow in Column B. Again, it's
meant to be blank ; And, ...... it's not looking right to top a blank
column with a clickable Arrow'd button (where there ain't nothing else
to look for, anyway).

6. But still, how to have that (Column B's) button removed ?

7. Please share your experience. Regards.

 

[Jim May]

Sub HideDropDown()
With ActiveSheet.UsedRange
.AutoFilter Field:=2, VisibleDropDown:=False
End With
End Sub

 

[tkt_tang]

Mr. Jim May,

Thank you for replying to my query. Will study.

Regards.