Z
zimfrancis
Hi Guys,
I have tried to use the code:
Private Sub Worksheet_Change(ByVal Target As Range)
Rows("6:18").EntireRow.Hidden = False
Rows("20:37").EntireRow.Hidden = False
If Range("c5") = "1" Then
Rows("13:18").EntireRow.Hidden = True
ElseIf Range("c5") = "2" Then
Rows("20:37").EntireRow.Hidden = True
End If
End Sub
The code works ok with one change event. I would like to use it 3-4
times in a worksheet, but get an ambiguous message.
Any ideas
I have tried to use the code:
Private Sub Worksheet_Change(ByVal Target As Range)
Rows("6:18").EntireRow.Hidden = False
Rows("20:37").EntireRow.Hidden = False
If Range("c5") = "1" Then
Rows("13:18").EntireRow.Hidden = True
ElseIf Range("c5") = "2" Then
Rows("20:37").EntireRow.Hidden = True
End If
End Sub
The code works ok with one change event. I would like to use it 3-4
times in a worksheet, but get an ambiguous message.
Any ideas