Dynamic Array with Text to Columns

  • Thread starter Thread starter sp00nix
  • Start date Start date
S

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)-)

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA to reference one cell in a range of one or more cells 4
Import Data from SQL server to excel 0
Extract data from SQL Server table into excel using Listbox Selection as criteria 0
dynamically referencing ranges with variables 1
Need to split large text field 13
Selecting next to highest number in an array? 2
vba array logic 3
Validating clipboard data 1

Back
Top