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

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.

Originally Posted by Kyle123

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).

Originally Posted by Kyle123

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.

Originally Posted by nilem

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.

Originally Posted by Kyle123

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...)

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!

Originally Posted by Kyle123

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.

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.

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

Please Login or Register  to view this content.