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

formula accross cells..when inserting a row..
 

See

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


In article ,
mike_mike 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