| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and paste versus copy and insert copied cells | New Users to Excel | |||
| insert row and copy formula | Excel Discussion (Misc queries) | |||
| Insert Row & Copy Formula | Excel Worksheet Functions | |||
| Automatically insert row and copy formula | Excel Worksheet Functions | |||
| Insert Formula and Copy to other cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
