View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sp00nix[_27_] sp00nix[_27_] is offline
external usenet poster
 
Posts: 1
Default 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