Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Via code, making 2 named Ranges Indentical, upon change | Excel Programming | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
If any cell in named range = 8 then shade named range | Excel Programming | |||
Blank cells in named range- how to ignore them when making my graph? Help plz! | Excel Discussion (Misc queries) |