Macro - Insert new row in table but copy selected cells from previous row

[antexity]

Here is my code:

Please Login or Register  to view this content.

Everything works great, it currently inserts a new blank row each time. But now looking to copy the previous cell from column B,D and E with the option to overwrite the data if necessary. All this will do is save some input time for the end user.

Side note, when we insert a new row, we have it configured that it locks all the previous rows of data to prevent data changes. ( .DataBodyRange.Locked = True)

Is this possible?

Much appreciated,

Jon

[nigelbloomy]

Does this do what you are looking for?

Please Login or Register  to view this content.

[antexity]

You addressed my issue, just altered the logic slightly, instead of (-1, 2) etc. I changed it to (0, 2) as every second row inserted would copy the alternate row behind the last one. Thank you so much. I also added Reputation!

[nigelbloomy]

Thank you for the rep. I am glad it helped.