Why won't split work for me?

[JenniferMurphy]

I copied this example from one of the M$FT pages, but when I try it, it gets a Run-time error "13": Type mismatch.

Dim sPrioAskCols As String
sPrioAskCols = "1 4 7 10 13"
Dim PrioAskCols() As Variant
PrioAskCols = Split(sPrioAskCols)

What am I doing wrong?

 

[JenniferMurphy]

I don't think the method is all that important although my preference is for declaring the variable as Variant (like you plan to do)... that way, VB will use the value as needed (you will not have to convert it to Longs first). And as you noted earlier, VB will convert a string number to a real number when you use it in a calculation but I think doing that may require an extra internal step on VB's part.

Perfect, thank you.

 

[JenniferMurphy]

I made this little table for future reference. As a little "thank you" for all the help, I'm posting it here in case it might be helpful to others.

Let me know if there are any other examples I should include.
aaa