When cell is modified Hide Entire Rows in a Range

Place this into the worksheet where you want the rows to hide - just with your design you say cell D12 is modified - with potentially hiding the range C12:C36 entire row then the cell you are using to discriminate which rows are hidden or not could potentially get hidden if the value in C12 is NA - just a design consideration - if row 12 gets hidden how do you then modify the value in D12? It would be ok if the value in D12 is dependant on some cell that will not end up being hidden by the code. You would execute this with a worksheet change event

Please Login or Register  to view this content.

This is what you need to do
Open the workbook and Hit ALT F11 - this will open the VB editor
Select the worksheet that contains the drop down validation list by double clicking the worksheet in the editor and copy and paste the code below into the editor

Please Login or Register  to view this content.

Then from the VB Editor menu at the top select Insert, then select Module. Copy your code into a module (making sure the Sub is called test as that is what the worksheet change event is calling i.e. it is calling the macro called test)
Close the editor and then try changing the value in D7 and your code should run if you have followed my instructions above.
Just looking at your code above you have not declared WS1 - I assume it is a worksheet - you should ensure that the variable is declared and initialised

Please Login or Register  to view this content.

You may have just posted a trimmed down version of your code however it is good practice to declare all variables