Insert new row at bottom of data range

Hi all

I am looking to create a macro that would repeat the bottom row of a data range directly underneath, and then delete the data contained within certain cells within that row (ie, A50, B50, D50, G50 only).

However, I don't seem to be able to insert a piece of code that tells the macro to repeat the last row, no matter where the last row is located (ie row 50, or row 51).

Is there any way of doing this?

Thanks guys

This code will repeat the last row:

Please Login or Register  to view this content.

try this...may be helpful for what you are looking for

Please Login or Register  to view this content.