Hi Nick,

Why is there a +b6- after your =? if you file is on your computer say
the desktop,

Shouldn't your file path be something like this?

='C:\Documents and Settings\Larry\Desktop\[10.28.05.xls]Sheet1'!$b$6.

Hope this helps

Larry


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=488374