Formula

[Chester1]

Hi

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

[Gary''s Student]

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

[Sandy Mann]

Chester1,

Dave McRitchie has a macro for both inserting a new row and copying the
formulas down at:

http://www.geocities.com/davemcritchie/excel/excel.htm


--
HTH

Sandy
In Perth, the ancient capital of Scotland

[email protected]
[email protected] with @tiscali.co.uk


"Chester1" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> Please can anyone tell me how to automatically copy formulae in to newly
> inserted blank rows.
> --
> Regards Clair