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