Hi.

I'm relatively new to VBA and somewhat inexperienced.

I'm trying to write a Sub in VBA which hides certain rows depending on a value selection (a list of nr, from 2 to 5) in a dropdown list.

Here's the code so far, i used Case Select but tried with IF too, wrote a Macro and a Sub too. It still doesn't work as it should.

---

If Not Intersect(Target, Range("C71")) Is Nothing Then

Select Case Range("C71")

Case "A single method": Call Macro_RC2
Case "More than one method": Call RC_nou

End Select
End If

---

Private Sub RC_nou()
Range("C72:C77").Value = ""
Rows("72:78").EntireRow.Hidden = False
Select Case Range("C72")

Case "2"
Rows("74").EntireRow.Hidden = False
Rows("75:77").EntireRow.Hidden = True

Case "3"
Rows("76:77").EntireRow.Hidden = True
Rows("74:75").EntireRow.Hidden = False

Case "4"
Rows("77:77").EntireRow.Hidden = True
Rows("74:76").EntireRow.Hidden = False
Case "5"
End Select

End Sub

The Macro is working fine, but this sub is not working as it should, it doesn't hide the rows when it should, depeding on the selection.
can you please help me solve this?

Thank you in advance!