Dim SelRng, R& Private Sub Worksheet_Change(ByVal Target As Range) If Range("A65536").End(xlUp).Row <> R Then For Each sh In Sheets If sh.Name <> "Sheet1" Then If Range("A65536").End(xlUp).Row < R Then sh.Range(SelRng).EntireRow.Delete Else sh.Range(SelRng).EntireRow.Insert End If End If Next End If End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range) SelRng = Target.Address