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

ArrayName = Split(SplitStr, vbCrLf)
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

        ReDim Preserve ArrayName (0 To UBound(ArrayName ), 1 To 2) As String
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