Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling an Array
Dim a(4,2) Is there any way to implement a(0 to 4,0) = Split ("22,33,44,55,66",",") a(0 to 4,1) = Split etc etc. Or must each array element be assigned individually? Thanks - Kirk |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling an Array
a = array(split("1 2 3"),split("1 2 3 4")): ?a(1)(3)
maybe? (returns 4 from the immediate window) "kirkm" wrote: Dim a(4,2) Is there any way to implement a(0 to 4,0) = Split ("22,33,44,55,66",",") a(0 to 4,1) = Split etc etc. Or must each array element be assigned individually? Thanks - Kirk |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling an Array
On Mon, 18 May 2009 20:59:02 -0700, Lori
wrote: a = array(split("1 2 3"),split("1 2 3 4")): ?a(1)(3) maybe? (returns 4 from the immediate window) Thanks Lori, I'd forgotten about Array.Opens up some nice possibilites. Cheers - Kirk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filling an Array Quickly | Excel Programming | |||
Filling an array with ranges | Excel Programming | |||
Filling an array with a Loop | Excel Programming | |||
filling a form with an array | Excel Programming | |||
Filling an array with data | Excel Worksheet Functions |