Forum Discussion

Jameshough97's avatar
Jameshough97
Copper Contributor
Dec 19, 2019

Hiding and unhiding rows based on a selection from a drop down box

Hi,

 

Trying to hide specific rows based on a drop down selection;

The code I am using is ; 

 

It does the hiding part but doesn't seem to unhide them?

 

I have attached the spreadsheet for context 

Any Ideas?

 

Thanks,

James

excel

2 Replies

  • Wanderlei Santos Filho's avatar
    Wanderlei Santos Filho
    Copper Contributor
    Dec 19, 2019

    Jameshough97 It would be easier to add a filter to the table. If you still want to use a drop-down (or better yet, a slicer), you could add a macro to set the filter for you. No hard-coded hiding of specific rows.

    • Jameshough97's avatar
      Jameshough97
      Copper Contributor
      Dec 20, 2019

      Wanderlei Santos Filho This is for a work project so I have to use a drop down for ease of use for everyone... I have to use the hide and unhide command due to only being allowed to show certain information when one item is selected in the drop down box. 

Resources