Sub ifthen()
If [F8] = 2 Then
Range("13:15,17:18").Select
Selection.EntireRow.Hidden = True
ElseIf [F8] = 3 Then
Range("14:15,17:18").Select
Selection.EntireRow.Hidden = True
ElseIf [F8] = 4 Then
Rows("13:15").Hidden = True
ElseIf [F8] = 5 Then
Rows("14:15").Hidden = True
ElseIf [F8] = 6 Then
Rows(13).Hidden = True
End If
End Sub
Sub HiddenFalse()
Rows("11:19").Select
Selection.EntireRow.Hidden = False
End Sub