ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   range in link? (https://www.excelbanter.com/excel-discussion-misc-queries/86588-range-link.html)

fungalspore

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



All times are GMT +1. The time now is 02:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com