| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing data stored in the worksheet (named range) in .xla file
Hi,
I'm really not skilled in programming, just what i need for engineering applications. I have this spreadsheet with macros and named ranges that i use to achieve the unit conversion (meters to feet, kilogram to pund, etc,etc). I want to have the access to the functions in this spreadsheet from several other workbooks that also performs calculations. So I thought on conveting my units conversion workbook to an add in, by saving it as .xla The problem is that i can not access the named ranges stored in the worksheets or see them if i do that. I do not want to loose the flexibility of adding units and conversion factors in the units conversion worksheet. The validation of the units entered is also important. Any Ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data validation using named range from another file | Excel Worksheet Functions | |||
| accessing named range | Excel Programming | |||
| Accessing Arrays stored as a Name | Excel Programming | |||
| Using a data validation list to look up a defined named range in another worksheet | Charts and Charting in Excel | |||
| accessing an address stored in another cell | Excel Worksheet Functions | |||
Threaded Mode
