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.