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

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

would be a basic approach.

--
Regards,
Tom Ogilvy

"Trish" wrote in message
...
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

I need to buy the book! But which one.
Thanks Tom
Regards
Trish
-----Original Message-----
iloc = Instr(1,ActiveCell," ",vbTextCompare)
iloc1 = Instr(iloc+1,ActiveCell," ",vbTextCompare)

would be a basic approach.

--
Regards,
Tom Ogilvy

"Trish" wrote in
message
...
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



.