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.
|