View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Lori Lori is offline
external usenet poster
 
Posts: 272
Default 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