Last Row Macro

M

Michael168

I need a macro which will always copy the last row of every sheet an
paste on the last row + 1 of the individual sheets.

I record the macro but that is not what I want and I don't know how t
modify the macro to make it works.

Can someone help?

Regards
Michae
 
P

pikus

lrow = ActiveSheet.UsedRange.Row _
ActiveSheet.UsedRange.Rows.Count
Rows(lrow).Copy
Rows(lrow + 1).Insert

That enough to get you started? - Piku
 
Top