| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Range to Array Oddity
I've just used a named range to fill an array and have found a
peculiarity that I'm not sure about. The named range was not contiguous and when assigning it to the array the array only appears to have used the second section of the range. Is this what normally happens and is there a work around? If I gave each part of the original range a separate name could I then read them easily in to the same array? How? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Named Range within an Array Formula | Excel Discussion (Misc queries) | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| Named range into an array | Excel Worksheet Functions | |||
| Array to named range conversion... | Excel Discussion (Misc queries) | |||
| Defined named range to array | Excel Programming | |||
Threaded Mode
