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

Copper Contributor

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?

0 Replies