Hi all,

I am writing a macro to copy the data in a cell in 1 excell book (book1) to another (book2)

the cell in book1 displays an answer to a formula that takes information from other cells in the book. all i want displayed in book2 is the answer that the formula in book1 gives. the problem i am comming across is that when i paste into the other book (book2) it gives me an error because it is trying to do the sum in the formula and the information is not in the cells in book2, there in book1. so basicly i only want the answer (displayed in the cell on book1) on book 2.

Can any1 help me with this as its consumed most of my morning at work lol

Thanks all

Mark