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.

Hi

Try this:

Range("Range1").FillDown

Regards,
Per

"RE: VLOOKUP fORMULA" <(E-Mail Removed)> skrev i
meddelelsen news:232E77B2-BC04-42AA-AEDD-(E-Mail Removed)...
> 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.
>
>

Can you explain little more I cant get you

"Per Jessen" wrote:

> Hi
>
> Try this:
>
> Range("Range1").FillDown
>
> Regards,
> Per
>
> "RE: VLOOKUP fORMULA" <(E-Mail Removed)> skrev i
> meddelelsen news:232E77B2-BC04-42AA-AEDD-(E-Mail Removed)...
> > 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.
> >
> >
>
>

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
>
>
>
>
> "RE: VLOOKUP fORMULA" <(E-Mail Removed)> skrev i
> meddelelsen news:F6F555F7-F56D-46BD-BBA3-(E-Mail Removed)...
> > Can you explain little more I cant get you
> >
> > "Per Jessen" wrote:
> >
> >> Hi
> >>
> >> Try this:
> >>
> >> Range("Range1").FillDown
> >>
> >> Regards,
> >> Per
> >>
> >> "RE: VLOOKUP fORMULA" <(E-Mail Removed)> skrev
> >> i
> >> meddelelsen news:232E77B2-BC04-42AA-AEDD-(E-Mail Removed)...
> >> > 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.
> >> >
> >> >
> >>
> >>
>
>

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
>
> "RE: VLOOKUP fORMULA" <(E-Mail Removed)> skrev i
> meddelelsen news:232E77B2-BC04-42AA-AEDD-(E-Mail Removed)...
> > 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.
> >
> >
>
>