Insert Row - Copy Formula From The Row Above

P

Phendrena

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,
 
P

Phendrena

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,
 
D

Dave Peterson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Need Help with a VBA subroutine 0
Repeating a row other than the 1st row as the header row in a table from next page 1
Insert Work Print Out - Page 1 Above Meeting Info - Other Pages below 0
Autonumber field in Excel that behaves the same as Access 0
How do I insert a row without the formula changing? 1
Dealing with a Pivot Table (when I don't want to) 0
How do I insert a row or rows between each row of text and copy the row above? 0

Top