How to unhide rows based on drop down box selection?

**jgomez** · 08-22-2012, 03:45 PM

Good afternoon all

I have this code here

Formula:

Please Login or Register  to view this content.

that sort of works... its meant to unhide the number of rows selected from the drop down box in cell G88. It will unhide one row but anything greater than 1 it will unhide more than selected. I don't know much of anything about this language that pops out the problem...

I also have

Formula:

Please Login or Register  to view this content.

this sort of works too! Rows 90:104 need to be remained hidden when the collateral type box in cell C88 is blank or if the option “Unsecured “is selected. It doesn’t work if Unsecured is selected & what I would like to add is if “NON-RE” is selected to only unhide rows 90:91 & row 101. If “RE” is selected then unhide rows 90:91 & 101:104.

Not sure what i'm doing here really... any help will be appreciated.