Hi there,
I have a string that will typically look like:
1,2,5,6,10-14,28
I would like each of the values between the ","'s as a seperate value preferably in an array in VBA.
Is this possible? I've done something simliar in VB a long while ago and its lost on me as to how to do this in VBA if it is at all possible.
Thanks in advance.
edit: Using Excel 97 on a Windows NT system.
I have a string that will typically look like:
1,2,5,6,10-14,28
I would like each of the values between the ","'s as a seperate value preferably in an array in VBA.
Is this possible? I've done something simliar in VB a long while ago and its lost on me as to how to do this in VBA if it is at all possible.
Thanks in advance.
edit: Using Excel 97 on a Windows NT system.