Hi,

I'm doing it by first keyying "=" in the formula bar and then clicking
on the referring cell. For example AG41 AND AH41 are merged so when i
refer to the cell the formula will appear as follows

='[Test.xls]Ken'!$AG$41:$AH$41

However if i manually change it to

='[Test.xls]Ken'!$AG$41

it works. Why is that? I have around 50 cells to refer to and this will
take some time manually changing each one, any faster way of doing it?


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