Let's say I want to create a two-dimensional array...
arr(1 to 2, 1 to 2)
...with the following values:
arr(1,1) = a
arr(2,1) = b
arr(1,2) = c
arr(2,2) = d
What is the easiest way to do it?
I would like something like this:
Any suggestions?
Dim arr(2,2) as long arr()={{a,b},{c,d}}
It is a good practice to assign variants to array as this will give flexibility on the type of data you are going to use.
If you want a dynamic array
Dim arr() as variant
Hey AB33
That's fine, but what is the easiest way to assign values to an array, regardless of type?
i.e. is there a way to do it in one line instead of:
arr(1,1) = a
arr(2,1) = b
arr(1,2) = c
arr(2,2) = d
You mean like
arr = Array(arr(i, 2), arr(i, 3), arr(i, 4))
Why do you need an array for that matrix?
You could use string functions, eg Mid, to return the individual items.
If posting code please use code tags, see here.
Below is a 7 x 50 matrix
I want to create an array with these values.
What would be the most efficient way of doing that?
37107287533902102798797998220837590246510135740250
46376937677490009712648124896970078050417018260538
74324986199524741059474233309513058123726617309629
91942213363574161572522430563301811072406154908250
23067588207539346171171980310421047513778063246676
89261670696623633820136378418383684178734361726757
28112879812849979408065481931592621691275889832738
You could use something like this, but you would need to refer to the elements of the array with arr(x)(y) and the array will be 0-indexed.
arr = Array(Array(1, 2), Array(3, 4)) MsgBox arr(1)(0)
Just remembered, here's another way to create a 2D array.
Dim arr As Variant arr = [{1,2;3,4}] MsgBox arr(2, 1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks