formula accross cells..when inserting a row..

Hi

When a user insert a row how do i get excel to automatically set a formula
in the cell.
For example "spreadsheet" with 3 rows..
1
2
3

when i insert a row
i want
1
2
3
4
not
1
2

3
thanks
mike

See

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


In article <CE430DFD-317D-484D-BF7F-33CF998277E1@microsoft.com>,
mike_mike <mikemike@discussions.microsoft.com> wrote:

> Hi
>
> When a user insert a row how do i get excel to automatically set a formula
> in the cell.
> For example "spreadsheet" with 3 rows..
> 1
> 2
> 3
>
> when i insert a row
> i want
> 1
> 2
> 3
> 4
> not
> 1
> 2
>
> 3
> thanks
> mike