If all the cells in the inserted row are to contain formulae, then you would
copy an old row containing the formulae to the newly inserted row.

If only some of the cells in the new row will contain formulae, then a macro
will be needed to selectively identify formulae in the old row and copy only
those cells to the newly inserted row.
--
Gary's Student


"Chester1" wrote:

Hi

Please can anyone tell me how to automatically copy formulae in to newly
inserted blank rows.
--
Regards Clair