Thread: Passing result of multiple split function results to 1 Array
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_2_] Alan Beban[_2_] is offline
external usenet poster
  
Posts: 783
Default Passing result of multiple split function results to 1 Array
Dave Peterson wrote:
Split was added in xl2k.

Oh good! So I tested it.

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

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
Reply With QuoteReply With Quote