How to hide rows based on cell number

[JessicaKinnear]

Hi, Is it possible to hide /unhide rows based on a number in a cell?

I basically have a cell F21 that I would like people to fill in based on how many tenants we have this could be 1 - 40.

If someone types 1 into the box, I'd like row F38 to show, if they type 2 I'd like rows 38 & 39 to show, type 3 38, 39 & 40 to show. And so on all the way up to 40 and row 77.

Is there a code that could make this happen?

Many thanks

 

[Fluff]

How about

Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.CountLarge > 1 Then Exit Sub
   If Target.Address(0, 0) = "F21" Then
      Rows("38:77").Hidden = True
      Rows(38).Resize(Target.Value).Hidden = False
   End If
End Sub

This needs to go in the relevant sheets code module

 

[JessicaKinnear]

How about

Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.CountLarge > 1 Then Exit Sub
   If Target.Address(0, 0) = "F21" Then
      Rows("38:77").Hidden = True
      Rows(38).Resize(Target.Value).Hidden = False
   End If
End Sub

This needs to go in the relevant sheets code module

great this worked - thank you!

 

[Fluff]

You're welcome & thanks for the feedback.