delete row from the main worksheet and at the same time from the second worksheet

[rodanny]

I want to be able to automatically delete a row from sheet 2 if I delete the same row in sheet 1.
For example, in sheet 1, I delete row 25 automatically to delete row 25 in sheet 2.
I would like in vbscript and without special buttons.
Thank you

 

[Jeffrey Mahoney]

I believe that VBScripts cannot detect worksheet events

If you use VBA macros to detect a worksheet change, you can get the address of the deleted row and apply it to the other sheet. Is the data on both sheets identical?

Something like this. It tests if the change affects all the columns (entire row) before deleting the same row on sheet2

Private Sub Worksheet_Change(ByVal Target As Range)
  Dim Addr As String
  
  Addr = Target.Address
  If Target.Columns.Count = ActiveSheet.Columns.Count Then
    Addr = Target.Address
    Sheets("Sheet2").Range(Addr).EntireRow.Delete
  End If
  
End Sub

 

[rodanny]

Exactly. That's what I wanted. Thank you very much.
I still have a few problems to clear up, but I'm posting a topic with the name of the problem so that it's easy for other people to find.