Hi!

Works ok for me:

='C:\TV\[Book2.xls]Sheet1'!$A$1 (A1,A2,B1,B2 are merged)

How are you referring to it?

Biff

"strikeuk" wrote in
message ...

Hey guys, does anyone know why i can't refer to a value from a merged
cell in another workbook? If it's not merged i could refer to it. Any
idea why?

Thanks


--
strikeuk
------------------------------------------------------------------------
strikeuk's Profile:
http://www.excelforum.com/member.php...o&userid=34512
View this thread: http://www.excelforum.com/showthread...hreadid=542760