[Suzanne S. Barnhill]

Yes, I see now that the macro is designed to operate on results rather than
the matrix. I guess I hadn't read enough of the original post to realize
that the OP had already extracted all the possible words.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Greg Maxey" wrote in message
...
Ms. Barnhill,

I was not proposing a macro to find correct or incorrect spelling in the
matrix. The OP indicated that EXCEL is used to sort the wheat from the
chaff and then the list of letter combinations is pasted into Word for
spell checking.

The macro Graham posted probably meets the OP's need. The macro I posted
will also hopefully meet the OP's need. Other than as another display of
his unbridled arrogance or to increase an already bloated post count I
don't really know why Peter T. Daniels posted. I do wish he would stop.

Suzanne S. Barnhill wrote:
In the matrix the OP presented, there are no correct words; the whole
thing is incorrect (except that, given the spaces between letters,
nothing will be marked as incorrect because it's all single letters).
In order to actually find correct words, you have to sort the wheat
from the chaff. A macro to do this would have to be very
sophisticated.

On Sep 19, 5:31 pm, SoNouveau
wrote:
I'm doing some work with games. We generate about 2,100 WORDS from a
grid of
3 letters by 7 letters:
T O I T S N Y
L R M B O R T
C A N K E A N

Only ONE word (!) is supposed to be correctly spelled when all is
said and done (in this case, LANTERN).

So, I create a list of all the various combinations of letters in
Excel, by
concatenation.

Then I cut and paste the 2,100 words into Word--and it does spell
checks for
me.

BUT, it's VERY hard to pick out the 1, 2, 3, or 4 CORRECTLY spelled
words as
I scan all 2,000 words. (And I do this again and again.)

I want to make sure I don't miss any!!!! So, what I really want is to
highlight in yellow, say, all the incorrect words or ... SOMEHOW, be
able to
sort/format/or whatever so that correctly spelled words are easy to
pick out
from these long columns of words.

Is that clear AT ALL!?!? LOL

--
Greg Maxey

See my web site http://gregmaxey.mvps.org
for an eclectic collection of Word Tips.

"It is not the critic who counts, not the man who points out how the
strong man stumbles, or where the doer of deeds could have done them
better. The credit belongs to the man in the arena, whose face is
marred by dust and sweat and blood, who strives valiantly...who knows
the great enthusiasms, the great devotions, who spends himself in a
worthy cause, who at the best knows in the end the triumph of high
achievement, and who at the worst, if he fails, at least fails while
daring greatly, so that his place shall never be with those cold and
timid souls who have never known neither victory nor defeat." - TR