Posted to microsoft.public.excel.programming
|
|
Passing result of multiple split function results to 1 Array
Split was added in xl2k.
Alan Beban wrote:
ExcelMonkey wrote:
I know I can use the split function on a string to return an array.
Array = Split(var2)
I have 8 string variables that I want to apply the split function to and I
then want to send all these elements into 1 Master Array. Do I still have to
create the 8 individual arrays as a middle step or can bypass this using some
sort of aggregation in brackets like:
MasterArray =
(Split(var1),Split(var2),Split(var3),Split(var4),S plit(var5),Split(var6),Split(var7),Split(var8))
Thanks
EM
I use Excel2002, so I don't have the Split function. But I suspect that
if the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, the
following will do what you are seeking:
MasterArray = MakeArray(Split(var1), Split(var2), . . .,Split(var8), 1)
If you want MasterArray to be 0-based rather than 1-based, change the 1
to 0. In either event, MasterArray will be one-dimensional.
Alan Beban
--
Dave Peterson
|