| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formulas in defined range
Pls any one help me.
I have a range of cells from B35:E42 named (Range1) Is there any way to copy the formulas in B35, C35, D35 & E35 to the end of the row that is Row E ie:- Copy the the formula from B35 till B42, C35 till C42, D35 ti D42 and E35 to E42. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy formulas in defined range
Hi
Try this: Range("Range1").FillDown Regards, Per " VLOOKUP fORMULA" skrev i meddelelsen ... Pls any one help me. I have a range of cells from B35:E42 named (Range1) Is there any way to copy the formulas in B35, C35, D35 & E35 to the end of the row that is Row E ie:- Copy the the formula from B35 till B42, C35 till C42, D35 ti D42 and E35 to E42. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy formulas in defined range
Can you explain little more I cant get you
"Per Jessen" wrote: Hi Try this: Range("Range1").FillDown Regards, Per " VLOOKUP fORMULA" skrev i meddelelsen ... Pls any one help me. I have a range of cells from B35:E42 named (Range1) Is there any way to copy the formulas in B35, C35, D35 & E35 to the end of the row that is Row E ie:- Copy the the formula from B35 till B42, C35 till C42, D35 ti D42 and E35 to E42. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy formulas in defined range
I tried this way is it correct, unfortunately it is not working.
Sub Macro1() Range("Range1").FillDown ' End Sub "Per Jessen" wrote: FillDown will copy formulas (or values and formatting) in the top cells of Range1 and paste into the rest of the rows in Range1. It is equal to when you manually drag down the content of a cell with the mouse. Hopes this helps. --- Per " VLOOKUP fORMULA" skrev i meddelelsen ... Can you explain little more I cant get you "Per Jessen" wrote: Hi Try this: Range("Range1").FillDown Regards, Per " VLOOKUP fORMULA" skrev i meddelelsen ... Pls any one help me. I have a range of cells from B35:E42 named (Range1) Is there any way to copy the formulas in B35, C35, D35 & E35 to the end of the row that is Row E ie:- Copy the the formula from B35 till B42, C35 till C42, D35 ti D42 and E35 to E42. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy formulas in defined range
I am sorry, It worked, the problem was my cell C was merged cell.
"Per Jessen" wrote: Hi Try this: Range("Range1").FillDown Regards, Per " VLOOKUP fORMULA" skrev i meddelelsen ... Pls any one help me. I have a range of cells from B35:E42 named (Range1) Is there any way to copy the formulas in B35, C35, D35 & E35 to the end of the row that is Row E ie:- Copy the the formula from B35 till B42, C35 till C42, D35 ti D42 and E35 to E42. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Defined Range Names in formulas | Excel Discussion (Misc queries) | |||
| Copy formulas in defined range | Excel Programming | |||
| Input formulas in a defined data range and convert results as valu | New Users to Excel | |||
| Name defined Range - Copy? | Excel Discussion (Misc queries) | |||
| dynamic range defined in VBA for use in formulas | Excel Programming | |||
Linear Mode
