Copying formulae into a row

[Francis Hookham]

Catastrophe! It should not happen but I have lost a Personal Macro Workbook
which included, among other things, a macro which one of the MVPs posted a
couple of years ago, which inserted a row above the selected row and copied
the formula in various cells into the new row BUT NOT the values. A minor
goodie, which I can sort out, is that it cleared any cell colouring

Please help with this invaluable macro, frequently used when I need to add a
record which contains many formulae linking fields

Thanks

Francis Hookham

 

[JE McGimpsey]

Catastrophe! It should not happen but I have lost a Personal Macro Workbook
which included, among other things, a macro which one of the MVPs posted a
couple of years ago, which inserted a row above the selected row and copied
the formula in various cells into the new row BUT NOT the values. A minor
goodie, which I can sort out, is that it cleared any cell colouring

Please help with this invaluable macro, frequently used when I need to add a
record which contains many formulae linking fields

Perhaps you're thinking of David McRitchie's InsertRowsAndFillFormulas():

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