Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Private Sub Worksheet_Change(ByVal Target As Range)
- If Range("D13").Value = "Unlimited" Then
- Rows("77").EntireRow.Hidden = True
- ElseIf Range("D13").Value = "Unlimited" Then
- Rows("78:82").EntireRow.Hidden = False
- End If
- If Range("D13").Value = "Limited" Then
- Rows("78:82").EntireRow.Hidden = True
- ElseIf Range("D13").Value = "Limited" Then
- Rows("77").EntireRow.Hidden = False
- End If
- If Range("D13").Value = "Select one" Then
- Rows("78:82").EntireRow.Hidden = False
- ElseIf Range("D13").Value = "Select one" Then
- Rows("77").EntireRow.Hidden = False
- End If
- End Sub
- Private Sub Hide_Unhide()
- If Range("D13").Value = "Select One" Then
- Rows("77:82").EntireRow.Hidden = false
- End if
- If Range("D13").Value = "Limited" Then
- Rows("77").EntireRow.Hidden = false
- Rows("78:82").EntireRow.Hidden = true
- ElseIf Range("D13").Value = "Unlimited" Then
- Rows("77").EntireRow.Hidden = true
- Rows("78:82").EntireRow.Hidden = False
- End If
- End Sub
Add Comment
Please, Sign In to add comment