Breakout numbers from a string and use/store each number as a variable

[mmmaxmmm]

So I've got a bunch of cells going down column A with strings like the below examples and I would like to be able to use each number in an IF function. Is there a way to store each number in A1 as a variable that I can use in an IF function and then once all the numbers are stored and used, move on to the next cell A2 and do the same thing? So 1 would be stored as a variable, used in an IF function. Then 25 would be stored as a variable, used in an IF function, then 50. Then it would reset or something, move on to A2 and start looping it like that through the end of column A. If anyone can post code, the IF function could just be the most simplest thing you can think of. My issue here is all the other stuff, not the IF function. Thank you to anyone who may be able to help!




A1 might have this as text: 1CA/25EA/50
A2 might have this as text: 1CA/100EA/5000PR/1000

 

[mmmaxmmm]

You are welcome. Glad it ended up working well for you.

Peter, just one quick edit I was hoping you could help me with. Where would I put MsgBox "Finished" so it lets me know when it's finished running through all the rows?

 

[Peter_SSs]

Where would I put MsgBox "Finished" so it lets me know when it's finished running through all the rows?

Immediately before End Sub