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
Bookmarks