Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 29
Default reference to external ranges

Hello,

From one workbook I need to reference to one range of another workbook.
Must I have both open ?

Thanks, Emiliano


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default reference to external ranges

No

Maybe this example will help to build the formulas
http://www.rondebruin.nl/summary2.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"eggpap" wrote in message ...
Hello,

From one workbook I need to reference to one range of another workbook.
Must I have both open ?

Thanks, Emiliano


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Refreshing External Data Ranges PJFry Excel Programming 4 September 24th 07 11:44 PM
Named Ranges in external Data Sources David Excel Programming 1 June 6th 05 02:55 PM
External Reference Iain Excel Discussion (Misc queries) 3 February 8th 05 06:53 PM
external reference Paul Levy Excel Programming 1 April 25th 04 03:45 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"