Hello:
I can link one excel file's cell to another excel file's cell.
But a cant seem to specify how to link a range of cells.
I tried this but w/ no luck.
='C:\Documents and Settings\Desktop[1.xls]Sheet1'!B9:g9
any help?
Thanks--
fungalspore
------------------------------------------------------------------------
fungalspore's Profile: www.excelforum.com/member.php...oamp;userid=34089
View this thread: www.excelforum.com/showthread...hreadid=538545Validate as Array Formula with Ctrl Shift Enter
HTH
--
AP
quot;fungalsporequot; gt; a
écrit dans le message de news:
...
gt;
gt; Hello:
gt;
gt; I can link one excel file's cell to another excel file's cell.
gt; But a cant seem to specify how to link a range of cells.
gt;
gt; I tried this but w/ no luck.
gt; ='C:\Documents and Settings\Desktop[1.xls]Sheet1'!B9:g9
gt;
gt; any help?
gt; Thanks
gt;
gt;
gt; --
gt; fungalspore
gt; ------------------------------------------------------------------------
gt; fungalspore's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34089
gt; View this thread: www.excelforum.com/showthread...hreadid=538545
gt;
- Oct 22 Sun 2006 20:09
range in link?
close
全站熱搜
留言列表
發表留言