Convert String array to Long array

[Jaafar Tribak]

Sub test()

    Dim s As String
    Dim Ar() As String
    
    s = "1,2,3,4,5"
    ar = Split(s, ",")
    MsgBox WorksheetFunction.Max(ar)

End Sub

The above Split Function returns a String array - Is there a way to convert this String array to a Long array so that we can obtain the Max element (ie: 5) but w/o looping though the array and converting each element one by one ?

 

[Jaafar Tribak]

This board never ceases to amaze me with its knowledgeable and helpful members.

PGC's solution does not only work directly on the string array (as opposed to the Evaluate Function which works on the 's' String variable) it also works on large String arrays. Beautiful !

Just how did using the Power function to solve this occur to you ? - I had tried using the Product function (Multiplying the array by 1) to force a data conversion in a similar way before posting the question on the board but obviously didn't work.

Again, Thanks to everybody who answered.

 

[pgc01]

Hi Jaafar

Nice problem, as usual. I'm glad this time I was able to contribute.

I knew that Sum or Product or SumProduct would'n work with the text parameter. Power seemed a good option and that's why I tested it.

Cheers!