Hi, Is it possible to store those keywords which is being found using Spellcheck option in excel.
I have a list of values in Column "A" on which I run the spellcheck. Now I want, excel(vba) to store those wrong values in sheet2 which is being found by spellcheck function so that I can populate their replacement (expanded version). For example there would be a value as "Mktg" in my list which will be found by spellcheck. "Mktg" has to be expanded as "Marketing" which I do manually and also enter this "mktg" in my repository manually for the future reference so that I can run my macro and replace "mktg" with "Marketing". I need your help in how to store those wrong keywords in sheet2 with each occurrence. Hope I am able to explain my problem. Any help is appreciated. Thanks, Anish -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel