Forum Discussion
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 ...
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.
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.
