Asc character

T

Trish

I have a string Ispace, I need to find what the position
is of the first and the second spaces within the string
are. Can someone help with the syntax. I have gotten the
if not question wrong and would appreciate any support:
Trish

Ispace = Trim(Right(ActiveCell, 10))

intI = 1
loop1:
If Not (Asc(Right(Ispace, intI), 32)) Then
intI = intI + 1
GoTo loop1
Else
Space = intI
 
T

Tom Ogilvy

iloc = Instr(1,ActiveCell," ",vbTextCompare)
iloc1 = Instr(iloc+1,ActiveCell," ",vbTextCompare)

would be a basic approach.
 
Top