Problem in restoring the hidden rows

Hi,

I am working on a workbook which has two worksheets.
In first worksheet "Solution Design", I have given conditions using drop down and accordingly I want rows to be hidden in other worksheet "Solution Pricing".

Action to do:

If in WS "Solution Design", L9 value = "YES" And L10 value = "Option 1"
Then in WS "Solution Pricing", hide rows Range("J121:J139,J149:J228")

Else If in WS "Solution Design", L9 value = "YES" And L10 value = "Option 2" Then in WS "Solution Pricing", hide rows Range ("J120:J171,J173:J190")

Else If in WS "Solution Design", L9 value = "YES" And L11 value = "Option 1"
Then in WS "Solution Pricing", hide rows Range("J171:J228")

Else If in WS "Solution Design", L9 value = "YES" And L11 value = "Option 2" Then in WS "Solution Pricing", hide rows Range("J120:J171")


I have tried writing a macro for this but unfortunately its not behaving properly. When I change the selection it makes change without unhiding the last hidden rows.
I think I am making a mistake in writing a False statement to unhide.

Below is the code I have tried. Please help in correcting this code.

Please Login or Register  to view this content.

Br,
gmalpani