Macro To Insert Row Below & Copy Formulas and Formats

[Harry Basra]

Hi all,

I'm trying to create a macro which inserts a new row under the last row, and also copies the formula and formatting from the rows above.

I have formulas in columns A, G & I which will need to be copied down.

I can create a new line, but having trouble copying the formulas

Any help is much appreciated.

[WideBoyDixon]

Needs careful manipulation to maintain the table formatting I think. Try this:

Please Login or Register  to view this content.

WBD

[Harry Basra]

thank you this is great!!