Nicholas,

You can find a list of Excel constants here - http://fox.wikis.com/wc.dll?Wiki~ExcelConstants~VFP

-Dan

>Hi
>
>I'm automating an excel spreadsheet.
>
>I have a formulae in one cell and I want to copy the result to another cell.
>
>I've recorded a macro using pastespecial but I'm not sure what I should put in my code for xlValue.
>
>Any ideas.
>
>Thanks
>
>
>
>Nick