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.

    Dim ElemID As String
        
    Range("B2").Value = "Element ID"
    ElemID = Application.InputBox("Define Element ID ranges. Input as shown in example, 202000:205599 702000:705599")
    Range("B1").Value = ElemID
    Range("B3:B").Formula = "=patlist($B$1,Row(),2)"
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!