Can inserted rows automatically include existing worksheet formula

[tgdavis]

I frequently need to insert rows to a worksheet which contains a formula
column. Is it possible to insert a row without having to manually copy down
the formula from the previous row?

Thank-you!

 

[Gord Dibben]

Have a look at David McRitchie's site for a macro to insert rows and maintain
formulas.

http://www.mvps.org/dmcritchie/excel/insrtrow.htm


Gord Dibben Excel MVP

 

[tgdavis]

Perfect, thank you so much!

Have a look at David McRitchie's site for a macro to insert rows and maintain
formulas.

http://www.mvps.org/dmcritchie/excel/insrtrow.htm


Gord Dibben Excel MVP