I find that if a formula refers to the top-left cell of a merged range
in a remote worksheet, the correct value is returned.

For example if you merge cells A1 through B2 of [doobie.xls]sheet1

The formula =[doobie.xls]sheet1!a1 will return the value in the merged
range.

The formulas =[doobie.xls]sheet1!a2 or The formula
=[doobie.xls]sheet1!b1

will return 0


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