When Inserting Rows in Excel, not all formulas copy to new row?
 

How do I get all of the formulas in the rows above and below the row that I
am inserting to automatically copy to the inserted row?

When Inserting Rows in Excel, not all formulas copy to new row?
 

Hi Dannyboy,

copy the above line right click insert copy

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"dannyboy" escreveu:

How do I get all of the formulas in the rows above and below the row that I
am inserting to automatically copy to the inserted row?

When Inserting Rows in Excel, not all formulas copy to new row?
 

Automatically will involve VBA.

David McRitchie has some code that does the job.

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


Gord Dibben MS Excel MVP

On Wed, 27 Sep 2006 12:40:02 -0700, dannyboy
wrote:

How do I get all of the formulas in the rows above and below the row that I
am inserting to automatically copy to the inserted row?