Length of User Input

[sperry2565]

I'm not entirely sure if this is even possible but here goes...

I prompt the user to input which "elements" they need for analysis. I place it in a single cell and then need to pull out all of those numbers into their own cells. I think my code explains it a little better than I can.

Please Login or Register  to view this content.

What I can't get is finding the length of the user input so I can have the patlist part of the code extend the right length....

Suggestions? Thank you!

[AB33]

Some idea.

Please Login or Register  to view this content.

[sperry2565]

I tried it with the example I posted and it tells me "2" which isn't right. Basically I need the code to know that I need all of the values between 202000 and 205599 and then all the values between 702000 and 705599..