for next loop problem

[EDUCATED MONKEY]

Yet another up date can some one please tell me how I change this code so that when the conditions in each section of the if else block are satisfied that the “next” can see the “For” and not report the next without for if I can get this sorted then just maybe the other post will be come redundant
i sure that ther must be guys like my self stuck on this kind of thing I have looked and look through the forum nothing that fits the bill as most have been were end statements have been missed<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
For Position = WordLen To 1 Step -1 <o></o>
fwsp = True<o></o>
<o></o>
If MyChar = " " And fwsp = True Then<o></o>
fwsp = False<o></o>
Next Position<o></o>
ElseIf MyChar = " " And fwsp = False Then<o></o>
S = Replace(S, " ", "-")<o></o>
Next Position<o></o>
ElseIf MyChar <> " " And fwsp = False Then<o></o>
Next Position<o></o>
End If<o></o>
Next Position

 

[RSXchin]

get rid of all "next position"s except for the last one.

 

[EDUCATED MONKEY]

Thank you I realise that once the condition is true then the other two are false so I agree with what you said however it is still not achieving the goal of putting hyphens between the initials and not the surname <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Original idea have a bool flip from true to false and check the along with the char in the string if thechar in the string = “ “ bool = true flip to false next time through loop the “ “ is Replace by “-“ so the result would be<o></o>
G K Aalborg changed to G-K Aalborg with no hyphen between the k and <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1lace>Aalborg</st1lace><o></o>
As it counts backwards I am wondering there is some anomily that I have over looked as it simply does not work and messing about with the false and true I cabn get G-K-Aalborg which is not the desired out come any ideas ?<o></o>
<o> </o>

 

[RSXchin]

It's not that the others are false, but it will choose the first one that is true.