>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

Have you tried recording what you're trying to do in Excel and then looking at the VBA code?