Is it possible to have a macro that will analyze words entered in an area and if they do not match the any of the words in a defined name range, to copy and paste it to the defined name range? And if it does match, do nothing.
edit: I think it would be best if the text was ran through the trim function prior to looking for a match.
Last edited by Butcher1; 11-05-2014 at 01:32 PM.
This is probably not exactly what you're looking for, but maybe a good start.
WordCheck.xlsm
Acts 4:12
Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.
It is definitely in the ball park of what I am looking for. Is it possible for the compare list to be a dynamic named range so that any no match word becomes part of the compare list?
Well, yea it's possible, but I have to ask: If the result of a no-match is to make it a match, then what's the point? Ultimately every word becomes a match.
The words would be going into a named range so that they would be accessible as a combo box option. Which would allow for easier data base searching, filtering and organization.
Ok, so if I understand correctly, your not saying to add the words to the "Compare" named range, but rather, add them to the NoMatch range, and then rename the range to include the addition.
The following should do it. I also put in a check to not add the word to the NoMatch range if it is already there, and to sort the range after each addition.
Please Login or Register to view this content.
Thank you, I have finally had time to sit down with this. Sorry for the delay.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks