Thread: VBA mid() function in microsoft.public.excel.programming

  I'm not "picking" on your Charlie, it's just I needed to attach this note to either you message or Peter T's message... I chose yours. Both you and Peter made the same suggestion (to change the second L to a one)... my question to the both of you is... How does that explain the OP's statement "The above code returns the correct value only on the 1st iteration"? It would seem...

  Thanks to all of you for your notes. Now I see where the problem was. What I want to do is to find a certain 'word' in a textstream and then place it in an Excel cell. Seems to me there was an API that did this well, but can't remember it. "Rick Rothstein" wrote: > Your posting is not very clear. You say you want to "find a string in > another string", but the code...

  Did I miss something? On the first iteration L would equal 1. The loop is from 1 to 10 -- the STRING started at zero ("0123...") "Rick Rothstein" wrote: > I'm not "picking" on your Charlie, it's just I needed to attach this note to > either you message or Peter T's message... I chose yours. > > Both you and Peter made the same...

  I'm not sure what your trying to do but the code will return 0 12 234 3456 45678 56789 6789 789 89 9 The reason it does that is for every loop L increases by 1 and your using L as both start position and lengthe of text to return so in (say) the 4th iteration of the loop your formula is Debug.Print Mid$("0123456789", 4, 4) From this you should be able to work out why the returned string gets shorter when L=6...

  If you are looking to find a string in another string use INSTR()..Check out the help on VBA InStr() If this post helps click Yes --------------- Jacob Skaria "vello" wrote: > Using XP & Excel2002 to find a string in another string, gets me weird results: > Dim S As String > Dim L As Long > > S = "0123456789" > For L = 1 To 10 > Debug.Print...

  change > Debug.Print Mid$(S, L, L) to Debug.Print Mid$(S, L, 1) at least that's what I assume you want! Regards, Peter T "vello" <vello@discussions.microsoft.com> wrote in message news:5688D375-6F6E-4514-AE9E-F8CC75C1C853@microsoft.com... > Using XP & Excel2002 to find a string in another string, gets me weird > results: > Dim S As String > Dim L As...