I have some code to hide/show rows when a command button is clicked e.g.
Private Sub CommandButton3_Click()
Rows ("58:123") Select
Selection.EntireRow.Hidden = False
I would like to replace the "58:123" with a dynamic named range. The idea is that the users can add/delete records within the dynamic range and the code will still hide/show the correct records. I have used named ranges but I cannot get the syntax correct (if it's possible?) to replace the "58:123". Any suggestions?
Thanks in advance