>I need to copy a formula in excel using the autofill method.
>I have tried the below and variations but with no joy.
>Has anyone done this before?
>
>ox.RANGE(ox.cells(440,4),ox.cells(440,4)).Select
>WITH ox.selection
> .Range.Autofill(.range(ox.cells(440.4),ox.cells(440,52)), 0)
>ENDWITH
>
>Thanks in Advance
>MArtin

---

ox is Excel or sheet ?

ox = createobject("Excel.Application")
....
with ox.ActiveWorkBook.ActiveSheet
 .Range(.cells(440,4),.cells(440,52)).Value = 0
* or xlA1 notation
* .Range("D440:AB440").Value = 0 && AB is imaginary - not col 52:)
endwith

Cetin