Insert New Row Command

[torontoguy]

Please Login or Register  to view this content.

that's a macro that I have as a button. However, I've got a formula in columns "I", "N" and "O" that I would like to copy down to the inserted row from the row above

can someone add this into my macro code? thanks!

[sweep]

Hi,

Give this a try

Please Login or Register  to view this content.

[torontoguy]

it didnt seem to help unfortunately

thanks for trying though
any other suggestions?

[shg]

Copy the whole row?

Please Login or Register  to view this content.

[royUK]

Try this

Please Login or Register  to view this content.

[torontoguy]

@shg: i'd like to but I don't want to copy the other columns, only the 3 mentioned

@royUK: it seems that the new inserted row gets created under the old one and doesn't keep track of the formula

for cols I, and for N and O, it computes the formula for the row above

[royUK]

Try

Please Login or Register  to view this content.

[torontoguy]

Try

Please Login or Register  to view this content.

ah thanks

seems to work, cept I'm guessing those 5s should be 9s :P
so I did that change.

Thanks a lot!