hide/unhide rows on dropdown selection VBA

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!

The problem is:

Please Login or Register  to view this content.

first you delete data from C72, and only then use Select

yes, i don't know how to clear data, if i don't delete data then it remains there.

I need it to work every time i operate a change, if i set "2" and then "a single method" the cell C72 has data, even if it's hidden, and then if i set 2 or 3 again it already contains data.

What should I change?

put

Please Login or Register  to view this content.

at the end of the sub. That`s all.

ok, i did that. But it still doesn't work.

May be need this?

Please Login or Register  to view this content.

i already tried it, it does not work. I select 2 and it does nothing.

because your macro starts only when C1 changes, and you trying to change C2

Please Login or Register  to view this content.

thank you so much, now it seems it works!