List of all arrays & last array?

[sasolini]

hey

Can someone pls tell me if it is posible & how to get the list of all arrays and/or last array of one string? What i want is that when i will split a string with slitp function i will be able to get a list of all arrays and/or the last array?

THX

 

[Mile-O]

I don't understand what you mean by a list of all arrays. I'm going to take a guess that you want to know the last element in an array...

if so, then take the following function as an example

Public Function CountElementsInArray(ByRef examples() As String) As Long
    CountElementsInArray = UBound(examples()) + 1
End Function

 

[sasolini]

hmmm sorry but somehow i dont get it...

but ill explay what i want:

i split var1 to var2:
var2 = split(var1,"/")

now i need the list of all arrays of var2:

arr1 = var2(1)
arr2 = var2(2)
arr3 = ... and so on...

So basicly what i want is to get the number of last array of var2?

 

[Mile-O]

Look at the function I gave above - it uses the UBound function which gives you the final element in an array. It's the opposite of LBound

 

[sasolini]

Oh...i get it...thx...it work just as i need it.