View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mike_mike
 
Posts: n/a
Default 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