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.

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.

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.

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.

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.