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 - 12 Apr 2008 14:37 GMT
Sub HideDropDown()
With ActiveSheet.UsedRange
.AutoFilter Field:=2, VisibleDropDown:=False
End With
End Sub
> 1. Enters an Excel WorkSheet.
>
[quoted text clipped - 14 lines]
>
> 7. Please share your experience. Regards.
tkt_tang@hotmail.com - 13 Apr 2008 06:47 GMT
Mr. Jim May,
Thank you for replying to my query. Will study.
Regards.