Can inserted rows automatically include existing worksheet formula

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!

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

On Tue, 20 Sep 2005 11:49:03 -0700, "tgdavis"
<[email protected]> wrote:

>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!
>

Perfect, thank you so much!


"Gord Dibben" wrote:

> 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
>
> On Tue, 20 Sep 2005 11:49:03 -0700, "tgdavis"
> <[email protected]> wrote:
>
> >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!
> >
>
>