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.