Convert list of numbers into an array

[mdmackillop]

Is there a simple method to convert a list of numbers, returned in an Input box for example, into an array or cell reference
eg

a = "2,4,6,8"
Arr = array(a)

b = "7,5"
set r = cells(b)

[OBP]

Do you want to do one, or both?

[mdmackillop]

Both. I know I can do a string manipulation, but is there an alternative?

[OBP]

Sorry, unlike range,which works fine, I can't even get the string to work with cells :banghead:

[Bob Phillips]

Sub Malcolm()
Dim a, b, Arr

a = "2,4,6,8"
Arr = Split(a, ",")
MsgBox Arr(0)


End Sub

[mdmackillop]

Thanks Bob,
I knew that, but never applied in that fashion!

[Bob Phillips]

Thanks Bob,
I knew that, but never applied in that fashion!

I use that technique all the time Malcolm. Setup a global constant as a string and then array it in my initialise procedure. Very handy.

[Bob Phillips]

Malcolm,

There is another way I should have showed you



Sub Malcolm2()
Dim ary

ary = [{"2","4","6","8"}]

End Sub


But I must admit I don't use that much, as it doesn't fell like 'real' VB to me.

[mdmackillop]

Not a "format" I've come across, but I'll have a play with it.
Thanks