Hi, I have used the below code to hide/unhide of row 40 & 41 according to the value of C39 cell "yes"/"no".
Private Sub Worksheet_Change(ByVal Target As Range)
If Target = Range("C39") Then
Select Case UCase(Taget.Value)
Case "yes"
Rows("40:41").EntireRow.Hidden = True
Case "no"
Rows("40:41").EntireRow.Hidden = False
End Select
End If
End Sub
But I am getting error "run time error 424" & it says "object required. Then it gets debug to this line of this code "Select Case UCase(Taget.Value)".
Can anyone help me please. I hope I made it understandable for anyone.
Bookmarks