Hide Rows Based on Cell Value

[tkbuc]

Hi Everyone,

I'm trying to write a simple VBA but I can't get it to work.

In the Worksheet code, I am trying to have the worksheet automatically hide certain rows based on a cell's value.

If cell E3 = IL, I would like rows 32-85 hidden
If cell E3 = ISA, I would like rows 12:31 hidden
If cell E3 = IL/ISA, I would like NO rows hidden

Would someone be able to advise as to what I am doing wrong with the code below:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Range("E3").Value = "IL" Then
Rows("32:85").EntireRow.Hidden = True


ElseIf Range("E3").Value = "ISA" Then
Rows("12:31").EntireRow.Hidden = True

End If

End Sub

[tkbuc]

I need to *BUMP* this as I am still at a lost.

[Fluff13]

In what way doesn't it work?

[tkbuc]

If I select a person's name via dropdown box, and their value in E3 is "IL", rows 32:85 hide as expected. However, If I choose another person's name, and their value in E3 changes to "ISA", rows 32:85 do not Unhide and rows 12:31 do not hide.

[Fluff13]

That doesn't answer my question.

[tkbuc]

Once rows are hidden, they are not unhidden if a different value is in E3.

[Fluff13]

Where is the dropdown located & is it a Data validation dropdown?

[tkbuc]

It's a drawn box with a Format Control linking an Input Range "Data!$B$4:$B$38", Cell Link "$B$3", and Drop Down Lines "8". It is listed on the same sheet.

[Fluff13]

Ok, how about

Please Login or Register  to view this content.

[tkbuc]

Yes! Thank you! Thank you! Thank you!

[Fluff13]

You're welcome & thanks for the feedback