making a named range available from an add-in
 

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.

making a named range available from an add-in
 

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

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

--
__________________________________
HTH

Bob

"Solutions Manager" wrote in
message ...
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.

making a named range available from an add-in
 

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

"Solutions Manager" wrote in
message ...
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.