Making 1-D Array Into 2-D When Using Split to Output to Sheet

[googlebot]

Hello all,

I am trying to do the following. I have a large string of data which I want to split based on vbCrLf. I can do this fine - simply using

Please Login or Register  to view this content.

Now, I would also like to be able to spit out ArrayName to column A without having to do a loop, as I have a lot of data to do this for and it takes a considerable amount of time to do it in loop format. Unfortunately I need to make the above array (ArrayName) into a multidimensional array to do this.

I cannot seem to find a way to do it. Even using something like

Please Login or Register  to view this content.

it does not like it, and I do not know a different way to do it. It gives a "Subscript out of range" error, presumably because I am trying to change the first array dimension as well and with preserve it needs to only modify the last dimension.

If there is a way to do this - essentially take a 1-D array created via the split function and create it in the form that can be quickly output into a worksheet - please let me know as it would be greatly appreciated.

Thanks in advance,
GoogleBot

[stanleydgromjr]

googlebot,

Please post your workbook - see "Manage Attachments".


Have a great day,
Stan

[googlebot]

googlebot,

Please post your workbook - see "Manage Attachments".


Have a great day,
Stan

Done, should be what you need.

[stanleydgromjr]

googlebot,

Here you go - nice challenge.

See the attached workbook "Copy of Example Workbook - googlebot - SDG.xlsm" with the updated "testing" macro.

Run the macro, and the information from the textbox, is entered into the two dimensional array "NewArray", and then displayed in range K1:L8, to show that it is working correctly.

When satisfied, remove the lines of code in the macro between the "''''''''''''''''''''''''" lines.


Have a great day,
Stan

[Andy Pope]

How about

Please Login or Register  to view this content.

[googlebot]

Andy,

I think that is exactly what I need. Now I just need to figure out how those functions all work so I can duplicate or manipulate that in the future, thank you

stanleydgromjr - I was looking to get around doing it in a loop format because having loops for many thousands of lines in multiple times still takes a relatively significant amount of time.

Thanks all, this is definitely "solved" now