Thanks again Dick. Again, It works! You're a genius, and a really nice
person. You said in your first post, that you didn't understand some
things I did. Understand, that I'm developing a unique and marketable
product (with a programmer that I conscripted), and am therefore
reluctant to divulge exactly what I'm doing in an open forum. A person
as nice as you, however, I don't fear. If your interested in knowing
what I'm doing, e-mail me, and I'll email you back what I'm doing.
. Who knows, you may even be interested in working
on the project for potential income.
In any case, because your obviously a nice person, I'm hesitant to ask
for any more help, so if you don't have time, just ignore the following
request:
Is it possible to modify that macro to change the first three lines
(Dim FndRng As Range, Dim FirstAdd As String, Dim i As Long) to make
the macro search each word in that cell, one at a time, and send the
results to F40, F41, F42, F43 etc?
Jim
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/