AW: SUB aufteilen auf mehrere kleinere SUBs
05.03.2024 12:33:34
Onur
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Value
Case "redpill":
bbb
Case "HV-BMW":
aaa
Case "HV-MBN":
aaa
Case "HV-VW":
bbb
End Select
End Sub
Sub aaa()
bbb
Rows("117:165").EntireRow.Hidden = True
Rows("301:480").EntireRow.Hidden = True
Range("Jackson").EntireRow.Hidden = True
Range("HV").EntireRow.Hidden = False
Range("Carter").EntireRow.Hidden = True
Range("Transim1").EntireRow.Hidden = False
Range("Tealc").EntireRow.Hidden = True
Range("Transim2").EntireRow.Hidden = False
Range("ONeill").EntireRow.Hidden = True
Range("Transim3").EntireRow.Hidden = False
Range("Hammond").EntireRow.Hidden = True
Range("Transim4").EntireRow.Hidden = False
Range("Quinn").EntireRow.Hidden = True
Range("Transim4b").EntireRow.Hidden = False
Range("Mitchell").EntireRow.Hidden = True
Range("Transim4c").EntireRow.Hidden = False
End Sub
Sub bbb()
Rows("10:650").EntireRow.Hidden = False
End Sub