Help using split()

[reneuend]

I created the following function but I get a mismatch error. Does the array have to be dimensioned to the right size first?

Function TestArray() As Variant()
    myData = "1,2,3"
    TestArray = Split(myData, ",")
End Function

Thanks!

 

[jongooligan]

Try

Function TestArray() As Variant()
    myData = "1,2,3"
    TestArray = Split(myData,",")
End Function

 

[doofusboy]

You're not telling the Split function everything it needs. You need to tell it WHAT to split on.

For example:

Split(myData,",")(0) should yield 1
Split(myData,",")(1) should yield 2
Split(myData,",")(2) should yield 3

Haven't tested it, but perhaps this is what you're after:

Function TestArray() As Variant()
    myData = "1,2,3"
    TestArray = Split(myData[B][COLOR=red],","[/COLOR][/B])
End Function

 

[Andrew Poulsom]

This worked for me:

Function testarray() As Variant
    Dim myData As String
    myData = "1,2,3"
    testarray = Split(myData, ",")
End Function
 
Sub Test()
    MsgBox testarray(0)
End Sub

 

[reneuend]

Sorry! I caught that issue late and fixed it in the thread, but I'm still getting a mismatch error in Excel 2007.

I found that if I set the function return as "String()" and not "Variant()" it works. I'm a bit surprised...does anyone know why this is?

I just saw your post Andrew. Thanks! I guess I don't need the parenthesis in the return declaration. variant instead of variant().

 

[Andrew Poulsom]

Did you try what I posted? Notice that I removed the parentheses after Variant.

 

[reneuend]

Yes! It worked perfectly. I had two issues that made this confusing for me. I appreciate everyone's input on this!

Cheers!