Insert Row - Copy Formula From The Row Above
 

Hi,

Is there anyway that I can insert a row and have it copy the formula from
certain cells in the row above? Such as from the columns C & L?

Thanks,

Insert Row - Copy Formula From The Row Above
 

David McRitchie has a macro that you may want to review:

http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

Phendrena wrote:

Hi,

Is there anyway that I can insert a row and have it copy the formula from
certain cells in the row above? Such as from the columns C & L?

Thanks,

--

Dave Peterson

Insert Row - Copy Formula From The Row Above
 

Many thanks that has helped a great deal and works like a charm.
However, this only works on unproteced worksheets.

Is there any way using the following :-

ActiveSheet.Unprotect & ActiveSheet.Protect DrawingObjects:=True,
Contents:=True, Scenarios:=True

That i can get it to use a password?

Thanks,



"Dave Peterson" wrote:

David McRitchie has a macro that you may want to review:

http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

Phendrena wrote:

Hi,

Is there anyway that I can insert a row and have it copy the formula from
certain cells in the row above? Such as from the columns C & L?

Thanks,

--

Dave Peterson

Insert Row - Copy Formula From The Row Above
 

Activesheet.unprotect password:="YourPasswordHere"
'code to insert the row and copy the formulas
ActiveSheet.Protect password:="YourPasswordHere", _
DrawingObjects:=True, Contents:=True, Scenarios:=True

Phendrena wrote:

Many thanks that has helped a great deal and works like a charm.
However, this only works on unproteced worksheets.

Is there any way using the following :-

ActiveSheet.Unprotect & ActiveSheet.Protect DrawingObjects:=True,
Contents:=True, Scenarios:=True

That i can get it to use a password?

Thanks,

"Dave Peterson" wrote:

David McRitchie has a macro that you may want to review:

http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

Phendrena wrote:

Hi,

Is there anyway that I can insert a row and have it copy the formula from
certain cells in the row above? Such as from the columns C & L?

Thanks,

--

Dave Peterson


--

Dave Peterson