| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning named range to a 2-dimensional array
I have a named range ("AdjHoursLookup") that currently occupies 12 cells (3
rows x 4 columns), but the number of cells will vary over time. Is it possible to assign the named range to a 2-dimensional array? When I excute the following two lines of code, for example, I get an "object required" error message. Dim AdjHoursArray As Range Set AdjHoursArray = Range("AdjHoursLookup").Value Any help would be greatly appreciated. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert into a range from a two dimensional array | Excel Programming | |||
| Load excel range into multi dimensional array | Excel Programming | |||
| Extracting unique entries and assigning it to a named range | Excel Discussion (Misc queries) | |||
| Extracting unique entries and assigning it to a named range | Excel Programming | |||
| Transferring part of a multi-dimensional array to a range in VBA | Excel Programming | |||
Threaded Mode
