Hide Rows Without Filter Arrows

Hi,

I've written a code to filter sheet rows on combo box value. But the code shows filter arrows as the rows get hidden.

My question of concern is how to make the code not to show the filter arrows but do hide the rows.

Following is my current code. Any help on this would be kindly appreciated.

Please Login or Register  to view this content.

See Help for the VisibleDropDown argument to the AutoFilter method.

If I may ask, where is "Help for the VisibleDropDown argument to the AutoFilter method"?

Open the Visual Basic Editor and enter AutoFilter Method in the Type a question for help box. Select the first item that pops up, Range.AutoFilter method.

Thanks for the help Shg. The filter arrow now gets hidden.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save