I have this code that works well to hide and unhide the selected rows. But if rows are added above I want the selected range to change in the macro. How do i do this?


Private Sub CheckBox12_Click()

Rows("431:460").Select
If Selection.EntireRow.Hidden = False Then
Selection.EntireRow.Hidden = True
Else
Selection.EntireRow.Hidden = False
End If
Range("$A$430").Select

End Sub