New to arrays-Convert 1D array to 2D (Need help on 1 line of code)

[mc84excel]

I am trying to convert a 1D array to a 2D. Below is where I am up to so far. I just need help with the Redim Preserve line. Can any of you nice array experts help out please?

Please Login or Register  to view this content.

[Kyle123]

Can't you just use the transpose function?

[mc84excel]

Can't you just use the transpose function?

Unfortunately no.

(I need the array to fill a ListBox and it seems there are issues with trying to .List a 1D array on a ListBox - but that's a topic for other threads).

[Kyle123]

Yeah have a look at my comment on that thread. Transposing gives you a 2 d array, wheres the issue?

[nilem]

ms84excel, could you attach a file with your troubled ListBox

[mc84excel]

Yeah have a look at my comment on that thread. Transposing gives you a 2 d array, wheres the issue?

Sorry Kyle. It doesn't work for me.

[mc84excel]

ms84excel, could you attach a file with your troubled ListBox

Hello nilem,

1. It would mean having to remove a large amount of confidential data. (I may have to go down that route if I cant convert a 1D array to a 2D array).
2. No offence intended - but would you mind posting this comment in the other thread? I would like to keep this thread focused on converting a 1D array to 2D. Thanks.

[Kyle123]

What does:

Sorry Kyle. It doesn't work for me.

Actually mean? In what way doesn't it work for you? Application.Transpose transposes an array:

Please Login or Register  to view this content.

[mc84excel]

What does:


Actually mean? In what way doesn't it work for you? Application.Transpose transposes an array:

Please Login or Register  to view this content.

Sorry that is my fault for not clarifying.

1. In my thread about 1D arrays to a ListBox, I have explained what happened when I tried your suggestion.
2. No offense intended - but would you please keep any posts relating to the "1D array to a ListBox" issue on that thread - not this one (which is meant to be about converting a 1D array to a 2D array...)

[mc84excel]

Everyone,

Please please keep your posts on this thread relating to the topic (Converting a 1D array to a 2D array).

If you have any suggestions on how to populate a ListBox with a 1D array, please post them in the other thread.

Thank You!

[Kyle123]

Eh? I'm not talking about listboxes, in this thread I'm talking bout conveting a 1d array to 2d

[mc84excel]

Eh? I'm not talking about listboxes, in this thread I'm talking bout conveting a 1d array to 2d

I apologise. It is my fault for misunderstanding.

I can transpose an array but how does that make a 1D array = 2D?

In my opening post, I am trying to add a 2nd row (of empty values) in order to make the 1D array to 2D.

[Kyle123]

Just put a break point in and inspect it in the locals window. Transpose works due to how Excel understands rows and columns, rows are single dimensioned, columns have 2 dimensions.

[mc84excel]

I tried transposing the 1D array but it didn't make it 2D. (Locals window still showed Variant/Variant(1 to 3).

I solved the sub - the code below will make a 1D array into a 2D array (Locals window will show Variant/Variant(1 to 3, 1 to 2) after running the sub).

This adds the 1D array contents to the 1st column. If you need the 1D array contents to the 1st row instead then change the last line of the sub to transpose the varArrayOutput.

Please Login or Register  to view this content.

[mc84excel]

Updated version. Note the module is set to Option Base 1

Please Login or Register  to view this content.