Hi,

In a line:

Range(Range("a2"), Range("a2").End(xlDown)).Formula

= "=n2*m2"

Or, if you need range ("a2") elsewhere, it would be a good

idea to store it in a variable:

Dim Rg As Range

Set Rg = Range("a2")

Range(Rg, Rg.End(xlDown)).Formula = "=n2*m2"

Now you can use Rg (representing Range A2) for other

purpose if needed

Regards,

Sbastien

Quote:

>-----Original Message-----

>Please how can I fill down a formula in column O "=N2*M2

> using the range as below

> Range("A2").Select

> Range(Selection, Selection.End(xlDown)).Select

>Thanks for any help here.

>Grah