Ah if its in a combo box it wont trigger the worksheet_change event.
it needs to be in a module sub triggered by the dropdown box.![]()
Sub DropDown1_Change() If Range("I4").Value = "HIDE" Then Rows("33:41").EntireRow.Hidden = True ElseIf Range("I4").Value = "UNHIDE" Then Rows("33:41").EntireRow.Hidden = False End If End Sub
Bookmarks