>>oXL.PasteSpecial(-4136)

xlPastValues = -4163 - not -4136



>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.