Dynamic Array with Text to Columns
 

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

Dynamic Array with Text to Columns
 

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" wrote in
message ...

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