jam03
09-09-2008, 07:57 AM
Hi guys this is actually my first post in here :)
I'm having a little problem and I thought you guys might come in help. Thank you in advance.
I am building my first excel Macro for one of my work.
Indeed, I have to compare about 2000 words (titles) stored in one column, and highlight the ones that are either the same or slightly different.
I wrote the code and I've managed to highlight the recurrent titles but here comes my problem. I also, like I said, need to to highlight the "slightly" different titles. By slightly, I mean that there can be either one letter or two different. For example : [Ecuador] and [Ecuadora] should be compared as positive.
Therefore, I need your help to code the comparison... Maybe I should play with the ASCII numbers, the number of characters in one title or I don't know... Is it actually possible using VBE?
I hope i've been clear, thank you very much for your time,
cheers,
Mateo
I'm having a little problem and I thought you guys might come in help. Thank you in advance.
I am building my first excel Macro for one of my work.
Indeed, I have to compare about 2000 words (titles) stored in one column, and highlight the ones that are either the same or slightly different.
I wrote the code and I've managed to highlight the recurrent titles but here comes my problem. I also, like I said, need to to highlight the "slightly" different titles. By slightly, I mean that there can be either one letter or two different. For example : [Ecuador] and [Ecuadora] should be compared as positive.
Therefore, I need your help to code the comparison... Maybe I should play with the ASCII numbers, the number of characters in one title or I don't know... Is it actually possible using VBE?
I hope i've been clear, thank you very much for your time,
cheers,
Mateo