Hi everybody,

I have just started using VBA with excel and ran into the following problem:

If I want to fill an array with an excel column I can do:

array_in = Range("A1:A7").Value

this works fine. But now I want to create a two dimensional array where I want to fill each dimension with a different excel column (the two columns have an empty column in between them). So I tried:

array_in = Range("A1:A7,C1:C7").Value

however this didn't worked out. Of course I can do:

array_in = Range("A1:C7").Value, but then I create a three dimensional array with the second dimension empty. This will work but seems rather silly to me;-) Maybe I am overlooking something obvious but as an excuse I am only a starter;-)

Can somebody help me?

Thanks,

Steve