Need help on this macro

[Paula]

I need to add someone to this macro-it is working correctlky (Iam brand new
at writing them), but I need to add one more thing and cannot figure it out.
I need to tell it to stop when it gets to text. I cannot tell it to only
read numeric because after the text are more numbers that I do not want. So
how do I tell it to read the numeric, but stop when it gets to text in the
first sentence of this macro? Thanks!

Range("I" & Range("Restraints").Row).End(xlToLeft).Select
Sheets("RESTRAINTS").Range("B5").Value = ActiveCell.Value

 

[Shane Devenshire]

So are you saying that your data looks like this


1
22
32
bb
44

and you want to stop on bb

or are you saying you data looks like this

123rt
765u
789p456

and you want just the numbers up to rt then up to U and finally up to p?

Or are you saying that you data looks like this

3243
54
765y
655
4432

and you want to stop on 765y?