I think you'll need to post a few more details....

Like:
what formula(s) are you using?
What steps are you doing?

***********
Regards,
Ron

XL2002, WinXP


"WesT" wrote:

I want to select the last cell in a coloumn and paste the value but the cell
contents is a forumula and everyhting I have tried results in the 1 or error
instead of the result of the formula.