Thanks Dan

I realised just before you posted that I should look in the constants. I think I was assuming something more complicated.

Nick

>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