Quick VBA value strip questions

[RompStar]

In my VBA code, currently, I take the value of a sheets name and assign it to a variable, like this:

StoreDir = ws.Name

this works great, my sheet names are digit/number combination, they can either be one digit, 2 or 3.

1 or 12 or 123, using various different digits or number combinations.

But now this has slightly changed, so it can be like this:

1 A
12 A
123 A

and there could be A, B, C, ......

I need to strip the digit/number before the space and just record the digit/number, its probably something easy, thanks for help...

 

[VoG]

Try

StoreDir = Val(Left(ws.Name, InStr(ws.Name, " ") - 1))

 

[RompStar]

Thanks, I will give it a try!

 

[RompStar]

worked perfectly, thanks!