Need VBA (For Loop) to find a **repeated** 3-character string in a record... if so, mark record TRUE

[Micron]

The numbers represent the ASCII table values for the alphabet. The Chr function tests if each letter in the sub string falls between a-z and A-Z.
Look up those two for more info.

[skydivetom]

All:

I apologize for the delayed response.

All in all, the assistance and responses/answers to my original question were superb and make this post one of my favorite ones in this forum.

As you know, this thread has been somewhat lengthy (4 pages) but every single comment/example has been truly insightful. I taken plenty of "notes" and saved all examples (in chronological order) into my toolbox.

I will share the query output w/ the team members and we will select the most apppropriate solution. From my perspective, it is rare to have so many solutions/variations for the same underlying question/problem.

At this time, I would like to highlight the fantastic responses/examples from *Micron*, *Vlad*, AND *Orange*.

Again, thank you for your patience and support!!

Tom

[orange]

Tom,

We are all happy to help.
Good luck with your project.

[Gicu]

Good luck with your project and post back if stuck
Cheers,