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:
MyArray = range("A1:C3")
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.