Dynamic Array with Text to Columns

[sp00nix]

Whats the best way to go about this:
Suppose i have 15 columns filled with data. Some of the columns contain data which can be delimited into additional columns.

I have the original 15 columns in a 2D array called myData (where values can be retrieved by using myData(r,c))

For the delimited data, i want to dynamically create additional arrays, but not sure how to create such a thing on the fly.

Should it be done like that, or by using class objects?

Where should i start? Should i use excel's built in function or VB's split? Any code out there like this?

[Tom Ogilvy]

Why not just pick up all the columns in the 2D array. Seems like it would
make more sense than tacking it on as additional rows at the bottom.

--
Regards,
Tom Ogilvy

"sp00nix" <[email protected]> wrote in
message news:[email protected]...
>
> Whats the best way to go about this:
> Suppose i have 15 columns filled with data. Some of the columns contain
> data which can be delimited into additional columns.
>
> I have the original 15 columns in a 2D array called myData (-where
> values can be retrieved by using myData(r,c)-)
>
> I want to be able to include the delimited data at the end of the
> array.
>
> Where should i start? Should i use excel's built in function or VB's
> split? Any code out there like this?
>
>
> --
> sp00nix
> ------------------------------------------------------------------------
> sp00nix's Profile:
http://www.excelforum.com/member.php...fo&userid=3934
> View this thread: http://www.excelforum.com/showthread...hreadid=526596
>