I apologize iof this is answered somewhere already, but I can't find
it.

I'm using the info in a worksheet to populate the cells in another. I
use the appropriate formula to reference the worksheet ie.
=Sheet1!A46. It works in some cells but in others it simply displays
the formula itself. The cells are formatted the same whether it be
text, number, currency, etc.

Any ideas would be greatly appreciated.


--
nia
------------------------------------------------------------------------
nia's Profile: http://www.excelforum.com/member.php...o&userid=29334
View this thread: http://www.excelforum.com/showthread...hreadid=490482