| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
3 dimension array using Excel names
Hello
I want to use name specification of 3-dim array (sheet, column, raw). First define var "rw" using Menu-Insert-Name-Insert as =Sheet1:Sheet3!$B$4:$D$5 Haw can i access any cell in "rw" range using VBA? Construction -----Range("rw")----- cause the 1004 error - Method 'Range' of object 'Global' failed Best regards, Konstantin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Redimming an array dynamically assigned from range (how to redim first dimension of a 2-D array? /or/ reverse the original array order) | Excel Programming | |||
| Re : Excel VBA Array to be expressed as a variation of Partial Dimension | Excel Programming | |||
| Put values into excel range from single dimension array | Excel Programming | |||
| Array transfer - 1 dimension v. 2 dimension | Excel Programming | |||
| Getting excel array dimension | Excel Programming | |||
Threaded Mode
