D Damn it May 5, 2004 #1 How do you have a formula insert into a certain cell when you insert a new row? Aaron
J JE McGimpsey May 5, 2004 #2 See David McRitchie's INSRTROW() macro: http://www.mvps.org/dmcritchie/excel/insrtrow.htm