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

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