That will only come out with the text of the link

"Special-K" wrote:


Why dont you just use CONCATENATE, something like e.g.

=CONCATENATE('A:\Folder1\',B2,'\[File1.xls]DATA')!$A$4


--
Special-K
------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=561101