Dynamic Array with Text to Columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sp00nix - 27 Mar 2006 00:54 GMT

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?

Signature

sp00nix

Reply to this Message

Tom Ogilvy - 27 Mar 2006 02:14 GMT

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.

Signature

Regards,
Tom Ogilvy

> Whats the best way to go about this:
> Suppose i have 15 columns filled with data. Some of the columns contain
[quoted text clipped - 8 lines]
> Where should i start? Should i use excel's built in function or VB's
> split? Any code out there like this?

Reply to this Message