making a named range available from an add-in

[Solutions Manager]

I created a worksheet with a defined range stored on a worksheet. I then
created and installed this sheet as an Excel add-in.

My question is as follows. How can I make the named range I created in my
workbook available once that workbook has been turned into an add-in. So far
I cannot find my named range.

 

[Bob Phillips]

Address it directly, assuming you want to do it fro another workbook

Workbooks("Stats 2009.xls").Names("All").RefersTo

 

[Peter T]

With respect to named ranges there's no difference whether the file is an
addin or otherwise. However an addin will never be the active workbook.

To refer to anything within 'self' start by qualifying with ThisWorkbook

Dim nm As Name
Set nm = Workbooks("myAddin.xla").Names("myName")
' or
Dim rng As Range
Set rng = ThisWorkbook.Names("myName").RefersToRange


If you want to refer to a name within some other addin
Set nm = Workbooks("myAddin.xla").Names("myName")

Regards,
Peter T