Transfer Array data to Spreadsheet

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:

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

Thanks for any help.

Thank you for the response.
The index gives me the number of "rows" in the array.

My actual code looks like this:

Please Login or Register  to view this content.

This now holds all of the range in the array.
I now want to go to another spreadsheet and just off load "columns" of the data into the worksheet.

Please Login or Register  to view this content.

This will now unload the data in the array which relates to "Column" 1 in the source data to column A in a fresh spreadsheet.

What I want to see is if I can unload this data without using this loop above in order to save run time as this is taking a long time with the amount of data that I have.

I thought you might be able to get the array to dump all data relating to a certain dimension into a spreadsheet?

Yes, that is the concept. I just need to digest it and use it in my code!

Is it possible to use 'Cells' instead of [range].resize?

e.g. [a1].resize to cells(1,1).resize

Thank you for your help!