VBA - add new Row after the last one, with add data

[dudi2s]

Hi,
I searched for a long time and could not find ,
i want to add new row after the last row in a table, and- copy Some specifics Cells from the last Row to the New Row

If it additionally checks if the line is empty, that's great!

Thanks a lot, David.

 

[dudi2s]

i find a way to make new row and put data , but if i want to take the last row formula .. (for Example- "=IF(N25="","",N25/L25)" but with auto change to next row (N26)

Sub AddRow01()

Dim ws As Worksheet
Set ws = ActiveSheet
Dim tbl As ListObject
Set tbl = ws.ListObjects("Sales")
Dim newrow As ListRow
Set newrow = tbl.ListRows.Add
With newrow
    .Range(1) = ""
    .Range(2) = ""
    .Range(3) = ""
    .Range(4) = ""
    .Range(5) = ""
    .Range(6) = ""
    .Range(7) = ""
    .Range(8) = "=V49"
    .Range(9) = ""
    .Range(10) = ""
    .Range(11) = ""
    .Range(12) = ""
    .Range(13) = ""
    .Range(14) = ""
    .Range(15) = ""
    


End With

End Sub