Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Passing Array Formula result to a variable in VBA (Leo) | Excel Programming | |||
Passing indexed array value to VBA function | Excel Programming | |||
split results to multiple worksheets | Excel Worksheet Functions | |||
Passing array of strings from DLL function to VBA | Excel Programming | |||
Passing array to a function | Excel Programming |