Hi, Ger!

>>
As you can see I'm having a few problems with this
OLE Automation
<<

The easiest way to find out such things is use Excel's macro recorder:
- start the recorder using the excel menu Tools/Macros/Recording...
- make your changes
- stop the recorder
- have a look at the recorded macro and translate it into the VFP syntax

BTW:
There is one important difference between Excel syntax and VFP syntax: In Excel you can deal with "named parameters", e.g.:

Selection.AutoFill Destination:=Range("A1:I1"), Type:=xlFillDefault

Now you have to search in the helpfile for the AutoFill method to find out the following syntax, because often the macro recorder don't record all parameters!!!!!:

.AutoFill(Destination, Type)

Now you know, "Destinatation" ist the first parameter, "Type" the second one - and you can convert this to VFP!

And if you have to omit some paramters, use the VFP comma syntax, e.g.

.AutoFill( , Type)