Formula
Hi
Please can anyone tell me how to automatically copy formulae in to newly inserted blank rows. -- Regards Clair |
Formula
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 |
Formula
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 with @tiscali.co.uk "Chester1" wrote in message ... Hi Please can anyone tell me how to automatically copy formulae in to newly inserted blank rows. -- Regards Clair |
All times are GMT +1. The time now is 03:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com