Not offhand Stefi. I would have to experiment to find out. I only use for
small arrays like yours.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Stefi" wrote in message
...
Thanks Bob, it worked great. Do you know the size limit? In my present
task I
had to create only a 2x7 array, but for the futere it would be good to
know
it.

Stefi


"Bob Phillips" ezt írta:

That doesn't actually create a 2d array, rather it creates an array of
arrays. Instead of indexing like rbetuk(1,2) you have to use
rbetuk(1)(2),
not a great problem, but not as we are taught to index into arrays (more
like Javascript multi-dimensional arrays).

This gives standard 2d arrays, bujt is limited in how big the array can
be

rdetuk = ActiveSheet.Evaluate("{""A"",""B"",""C"";""D"", ""E"",
""F"";""G"",
""H"", ""I""}")

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Jay" wrote in message
...
Try using arrays themselves as arguments:

rbetuk = Array(Array("A", "B", "C"), Array("D", "E", "F"), Array("G",
"H",
"I"))

You can test this by reading the array 'in' and 'out' with the
following
test code:

Sub stefi()
rbetuk = Array(Array("A", "B", "C"), _
Array("D", "E", "F"), _
Array("G", "H", "I"))
For Each itm In rbetuk
For Each itm2 In itm
MsgBox itm2
Next 'itm2
Next 'itm
End Sub

--
Jay


"Stefi" wrote:

Hi All,

rbetuk = Array("A", "B", "C")

is a very convenient way of creating arrays, but it creates only a 3x1
dimension array. Can I declare a 3x2 or 3x3 dimension array in this
way?


Thanks,
Stefi