Hide and Unhide Rows Macro

[ExcelAverage]

May I post this one query I am having regarding hiding and unhiding rows.
I have the following code to hide and unhide row 5-34. I attached the macro to one button. My problem is I sometimes needed to insert row/s between 5-34. How do I make my code flexible that it will adjust the number of rows if I inserted new ones (varying number of inserted row). Say 5-34 should be 5-39 if I added another 5 rows. Below is the code I found online, too. I am looking for that capability same as dynamic range.

Sub Hide_Unhide()    
        With Rows("5:34").Select
       .EntireRow.Hidden = Not .EntireRow.Hidden
        End With
End Sub

Thanks for the help
-JM

 

[Gary McMaster]

One way would be to use "named ranges". The following sample assumes that row 5 has been named "Start" and row 34 has been named "Finish". The name(s) will move up/down as rows are deleted/inserted.

Hope it helps.

Gary

Sub Hide_Unhide()

Dim oTarget As Range

Set oTarget = Range("Start:Finish")
oTarget.EntireRow.Hidden = Not oTarget.EntireRow.Hidden
        
End Sub