Hide/unhide rows

[abugharibh]

Hello
trying to unhide/hide rows based on cell value. the cell is : N4, and it contains years from 2018-2020
im using this code:

If Target.Address(False, False) = "N4" Then
Select Case Target.Value
Case "2018: Rows("7:57").Hidden = False
Case "2019": Rows("60:110").Hidden = False
Case "2020": Rows("113:163").Hidden = False

End Select
End If
End Sub

it does unhide the rows i want , but i dont know how to make it hide all other rows. e.g. when N4=2019 , i want to unhide rows 60:110 but at the same time hide rows 7:57 and 113:163

Thanks in advance

 

[Joe4]

Why not add a line of code to hide ALL those lines first (before your "Select Case..." line), then the rest of your code will just unhide the correct section, based on the selection?

 

[abugharibh]

Why not add a line of code to hide ALL those lines first (before your "Select Case..." line), then the rest of your code will just unhide the correct section, based on the selection?

Thanks alot. I don’t know a line of code that hides those lines though. Any example/ideas will be very helpful.

 

[abugharibh]

Fixed it. Thank you very much.

 

[Joe4]

You are welcome.