In cell in the same worksheet, you could use a formula like:
=if(a1="","",a1)

in a cell in a different worksheet in the same workbook:
=if(sheet1!a1="","",sheet1!a1)

Between two workbooks:
=IF([book1.xls]Sheet1!$A$1="","",[book1.xls]Sheet1!$A$1)

I let excel do the heavy lifting when the formula gets too long for me.

I edit|Copy the cell
then Edit|paste special|links
and just mimic what it pasted in my =IF() statement.



DangerMouse wrote:

I dont wish to hi-jack this thread, but might I ask how you accomplished
the displaying of blank cells as blanks in a linked workbook?

thanks

steve

--
DangerMouse
------------------------------------------------------------------------
DangerMouse's Profile: http://www.excelforum.com/member.php...o&userid=27755
View this thread: http://www.excelforum.com/showthread...hreadid=552656

--

Dave Peterson