Hello, If I have a cell that has the following information:
DEF(352) HHY(24533) KLDD(3334)
And I extract that to a String with the following code:
GetManufInfo = Sheets(CurrSh).Range("F5:F5")
How do I now store each entry in a list or somthing?
What I want to do is take a string like the above (It can
have any number of Entrys) and store each entry into a list so I can work with them seperate.
I cannot figure out
how to create a List or Array or somthing that can hold some number of Strings. I'v never used VB before but work is making
me use it for this project.
My Ultimate goal is to take the string "DEF(352) HHY(24533) KLDD(3334)"
which is in one cell and break it up into (in this case) 3 strings that will be placed into their own cells.
help is greatly appriciated.