>I am now trying to paste as values from one worksheet to another. Everything is fine until I use the command:
> oXL.Selection.PasteSpecial(-4163)
>This returns an error message:
> OLE iException code 1004 from Excel
> Unable to get PasteSpecial property of the range class.
>
>Any ideas.

I don't know what the problem is, but might I suggest you start a new thread?