Forum Discussion
venkat001
12 years agoOccasional Contributor
Thanks Hugo
Well, split() function is good when i know my array with pre-defined delimiter, suppose if i want read cell values from excel and want to put it an array elements. In that case we may not know array size so we need to read from for loop.
Ex.
Sub array
Dim arr()
For i=0 to 10
a(i)= Excel.cells(i,1) ' getting error in a(i)
Next
End sub
Regards,
venkates k
Well, split() function is good when i know my array with pre-defined delimiter, suppose if i want read cell values from excel and want to put it an array elements. In that case we may not know array size so we need to read from for loop.
Ex.
Sub array
Dim arr()
For i=0 to 10
a(i)= Excel.cells(i,1) ' getting error in a(i)
Next
End sub
Regards,
venkates k