The code looks valid and it's gonna do what it's supposed to.
You don't need a Do While.
This snippet extracts the first and last character of the string which is then used in the IF statement for comparison.
str1stCharacter = Microsoft.VisualBasic.Left(strInput, 1) strlstCharacter = Microsoft.VisualBasic.Left(strInput, 4)
What, exactly, is it that you want to do and you get stuck on?
Reputation Points: 87
Solved Threads: 128
Practically a Master Poster
Offline 652 posts
since Jun 2006