Home

Need help with Filter dropdowns - how to use: Sub HideArrowsSpecificFields() or Sub HideAutoFilterDr

JEM618
Occasional Visitor

I have found the VB code above with examples. I have tried it on my worksheet to no avail.

  

Worksheet (sheet 19) has 44 Columns: A:AR (Columns 1-44) 371 Rows

Range is: A1:AR371

 

Dropdown arrows are in Row 4, so filter range is A4:AR371

 

In the following columns, Row 4, I want to hide dropdown arrows: 1, 7, 8, 9, 10, 11, 12, 18, 19, 20, 21, 22, 23, 29, 30, 31, 32, 33, 34, 40, 41, 42, 43, 44 

 

In the following columns, Row 4, I want to show dropdown arrows: 2, 3, 4, 5, 6, 13, 14, 15, 16, 17, 24, 25, 26, 27, 28, 35, 36, 37, 38, 39

 

Can anyone point me in the right direction?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies