Hi Cadillac. If you copy the entire row, above the one where you are going
to insert a new row, and then paste insert row, the formulas will be copied
and the cell references will change. HTH
--
Sincerely, Michael Colvin


"Cadillac Williams" wrote:

Hi,

I have a large worksheet that has a number of fairly complex formulas that
are repeated in each row with only the row number reference changing. When I
insert a new row in between two existing rows that contain formulas I would
like excel to automatically insert the formulas I have in the row above it
into my new row. Excel already does this with my formatting, I want to know
how to do it with my formulas as well.