Range - Formula

[RE: VLOOKUP fORMULA]

Any one please help me......?

Is there any way to give a formula to a named range.
for example:-

I have given a name Range1 for D1020
I need to give a formula <a1+a2>
and copy the formula to D1020

Tks

 

[Sheeloo]

Not sure what you want but try this;
type your name in the address box on the top-left and press enter
this will select the named range
type your formula and then press CTRL-ENTER ... your formula will be copied
to all cells in the range.

 

[RE: VLOOKUP fORMULA]

I am sorry Sheeloo, I was asking for a code

In the below code I have to apply the formula in D10
Range("Range1").FillDown


I was trying to enter a forumla =sum(a1+a2) in all cells (D1020) without
applying a formula manually in D10.

 

[Sheeloo]

Try
Range("D1020").Select
Selection.Formula = "=SUM(A1+A2)"

Use SUM($A$! + $A$2) if you want Sum(A1+A2) in all cells and not Sum(A2+A3)
and so on

 

[RE: VLOOKUP fORMULA]

I cant define the range as D1020, it may vary according to the line
inserted/deleted above.
Is there any other way to define the formula using range name (Range1)?

tks

 

[Sheeloo]

Try
Range(ActiveWorkbook.Names("Range1").RefersToRange.Address).Select
Selection.Formula = "=SUM(A1+A2)"