Record macro hide cells breaks when rows or inserted or deleted

[BWellman]

Hey all,

I recorded a simple macro and linked it to a button that hides rows 10-15 in a worksheet. There is another button that unhides the same rows. What do I need to add to the code to stop it from breaking when I insert or delete rows before 10-15?

Do I have to name that range and then look up that named range? If so, how do I do that?

I have attached an example for reference, and copied the code below.

Cheers,
B

This is the code:

Sub HideCells()
'
' HideCells Macro
'

'
Rows("10:15").Select
Selection.EntireRow.Hidden = True
End Sub
Sub UnhideCells()
'
' UnhideCells Macro
'

'
Rows("9:16").Select
Selection.EntireRow.Hidden = False
Range("B9").Select
End Sub

[TMS]

It would be something like

Please Login or Register  to view this content.

where RowsToHide is your Named Range and refers to cells in the rows to be hidden/unhidden.

[BWellman]

Thought so, but nothing was coming up on my search. Sorry for the terrible question and thanks for the help!

B

[TMS]

You're welcome. Thanks for the rep.



The only "terrible question" is one you don't ask