Guest User

Untitled

a guest
Apr 20th, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. Private Sub Worksheet_Change(ByVal Target As Range)
  2. If Range("D13").Value = "Unlimited" Then
  3. Rows("77").EntireRow.Hidden = True
  4. ElseIf Range("D13").Value = "Unlimited" Then
  5. Rows("78:82").EntireRow.Hidden = False
  6. End If
  7. If Range("D13").Value = "Limited" Then
  8. Rows("78:82").EntireRow.Hidden = True
  9. ElseIf Range("D13").Value = "Limited" Then
  10. Rows("77").EntireRow.Hidden = False
  11. End If
  12. If Range("D13").Value = "Select one" Then
  13. Rows("78:82").EntireRow.Hidden = False
  14. ElseIf Range("D13").Value = "Select one" Then
  15. Rows("77").EntireRow.Hidden = False
  16. End If
  17. End Sub
  18.  
  19. Private Sub Hide_Unhide()
  20.  
  21. If Range("D13").Value = "Select One" Then
  22. Rows("77:82").EntireRow.Hidden = false
  23. End if
  24.  
  25. If Range("D13").Value = "Limited" Then
  26. Rows("77").EntireRow.Hidden = false
  27. Rows("78:82").EntireRow.Hidden = true
  28.  
  29. ElseIf Range("D13").Value = "Unlimited" Then
  30. Rows("77").EntireRow.Hidden = true
  31. Rows("78:82").EntireRow.Hidden = False
  32.  
  33. End If
  34.  
  35. End Sub
Add Comment
Please, Sign In to add comment