Copy row attributes to inserted row below

[raschwab]

I am endeavouring to insert a new row in my worksheet and copy the formulas and values from the previous row. I have tried various schemes, the latest being:

Worksheets("Trade Record").Row(i).EntireRow.Copy Destination:=Worksheets("Trade Record").Row(i + 1)

This should be simple but I am missing something. Would very much appreciate someone's assitance.

Rick Schwab

 

[Boller]

I am endeavouring to insert a new row in my worksheet and copy the formulas and values from the previous row. I have tried various schemes, the latest being:

Worksheets("Trade Record").Row(i).EntireRow.Copy Destination:=Worksheets("Trade Record").Row(i + 1)

This should be simple but I am missing something. Would very much appreciate someone's assitance.

Rick Schwab

Have you tried using the macro recorder ?

 

[raschwab]

Appreciate your suggestion and realize tht I should have given this a try in lieu of scouring the Internet for some code. I learned a couple of things by running the macro recorder. Bottom line I did get it to work.

Rick Schwab