Re : Excel to Insert an AutoFilter (at will)
 

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.

Re : Excel to Insert an AutoFilter (at will)
 

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

" wrote:

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.

Re : Excel to Insert an AutoFilter (at will)
 

Mr. Jim May,

Thank you for replying to my query. Will study.

Regards.