Hello everyone,

For my excel sheet, I want to insert a row at the end of the data and then copy the formulas and format painting from the row above (above the newly created row).

For now I am able to only find the row at the end of the data. Can someone please help me how i can then copy the formulas and format painting from the row above (above the newly created row)?

Code:

Sub Insert1()

Range("CD_1").End(xlDown).Offset(1, 0).Select
Selection.EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove


End Sub



Thank you very much
Numair