Been trying for days to write code that:

1. Searches for the first/next occurrence of both of 2 strings
in the combined text of two adjacent cells (A and B) in the
same row, within a specified 2-column range.

2. When a match is found, displays the combined A+B and prompts
the user to accept it (write it out to a text file) or look for
the next match.

3. Repeats Step 2 until user accepts the displayed A+B or until
no more matches are found at which point it should stop. It's
the stopping that's giving me the most trouble.

The code is such a mess now that I can't even make sense of it,
so I'm gonna start over in the morning. Meanwhile, does anyone
who has faced this chore before have any advice on structure?

Concatenating A and B beforehand is not an option because the
file grows extra records on the fly.

Thanks in advance for any clues at all.

--
Mark Tangard , Microsoft Word MVP
"Life is nothing if you're not obsessed." --John Waters