I have a list of values in :
Sheet8.Range("E:E")
that are formatted as:
ST 1234 ' IE "ST_1234" where "_" = Space

I want to place the Maximum Numerical Value +1 into a Textbox on a Userform,
But to date i have yet worked out how to manage it?

Any One assist me ?
Corey....