range in link?
 

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: http://www.excelforum.com/member.php...o&userid=34089
View this thread: http://www.excelforum.com/showthread...hreadid=538545

range in link?
 

Validate as Array Formula with Ctrl+Shift+Enter

HTH
--
AP

"fungalspore" a
écrit dans le message de news:
...

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:
http://www.excelforum.com/member.php...o&userid=34089
View this thread: http://www.excelforum.com/showthread...hreadid=538545