kittronald formulated on Friday :
Is it possible to import a named range from another workbook like
you would import a text file ?

In Workbook1.xlsb there is a named range called DATA that
references A1:C10.

I'm trying to import the data from that named range into
Workbook2.xlsb and keep that connection linked.

Any ideas ?



- Ronald K.

Try a cell formula...

=Workbook1.xlsb!DATA
..if a workbook level name

=[Workbook1.xlsb]Sheet1!DATA
..if a sheet level name

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc