close

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;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()