| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing Arrays stored as a Name
I am currently adapting some old VBA code and want store all my
configuration settings as Names to eliminate having a separate worksheet for that. I have loaded strings and arrays into names and have been successful in pulling the strings back out into my code but when pulling the array back can only access the first value in the array and cannot find a method to pull specific rows/columns (i.e. array(2,3)). I have searched online and in VBA books I have and cannot find anything on this and none of my ideas for making it work have succeeded so does anyone know if this is even possible? Dustin Russell |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Functions, Arrays and number/text stored as text | Excel Worksheet Functions | |||
| Working with ranges in arrays... or an introduction to arrays | Excel Programming | |||
| Arrays - declaration, adding values to arrays and calculation | Excel Programming | |||
| accessing an address stored in another cell | Excel Worksheet Functions | |||
| array of arrays stored in Name: POSSIBLE? | Excel Programming | |||
Threaded Mode
