Hi Guys,
I'm trying to transfer information I have held in a table format into a database format.
I'm using array variables to hold the table data and now I'm trying to use this data held within the array to produce a database.
For example:
A 1 2
B 2 3
C 3 4
into
A1
A2
B2
B3
C3
C4
My code would look like this:
Where MyArray(1,1) = "A" and MyArray(3,3) = "4"
What I want to do is refer to one "column" of data within the array so that it will return for column A (or array position 1):
A
B
C
I can use a loop to do this for me but I was wondering whether there was a solution which would be a little neater?
This doesn't work but something like:
MyArray(1,1) to MyArray(1,3)
Thanks for any help.
Bookmarks