I have been trying to get the paste one area of a worksheet to another using the pastespecial and pastevalues functions in Excel. I do not think I have the right syntax in VFP for the command. The correct syntax in Visual Basic help documents for pastespecial is:

expression.PasteSpecial(Paste, Operation, SkipBlanks, Transpose)

I translate this in VFP to

oXL.PasteSpecial(-4136)
The -4136 = xlPasteValues

When I use this an error message is returned:

Unable to get the PasteSpecial property of the range class.
Any ideas on the correct syntax in VFP.