Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$7" Then
If Target.Value = 1 Then
Rows("8:24").Hidden = False
Rows("25:38").Hidden = True
Else
If Target.Value = 2 Then
Rows("8:24").Hidden = True
Rows("25:38").Hidden = False
End If
End If
End If
End Sub