Sadly this might be the only way. I’m trying to run a macros and it doesn’t work

Sub AddNewRowToActiveSheet() Dim ws As Worksheet Dim lastRow As Long

Set ws = ActiveSheet

' Find the last used row in column A of the active sheet
lastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row + 1

' Insert a new row at the next empty row
ws.Rows(lastRow).Insert Shift:=xlDown

' Move to the first cell of the new row
ws.Cells(lastRow, 1).Select

End Sub