Copy formulas in defined range

[RE: VLOOKUP fORMULA]

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.

 

[Per Jessen]

Hi

Try this:

Range("Range1").FillDown

Regards,
Per

 

[RE: VLOOKUP fORMULA]

Can you explain little more I cant get you

Hi

Try this:

Range("Range1").FillDown

Regards,
Per

 

[RE: VLOOKUP fORMULA]

I tried this way is it correct, unfortunately it is not working.

Sub Macro1()

Range("Range1").FillDown
'
End Sub

 

[RE: VLOOKUP fORMULA]

I am sorry, It worked, the problem was my cell C was merged cell.