I have a sheet with multiple columns with one column containing "City, State" combinations. These are from manual input so there are many misspellings (file provided to me so I can't address data validation, just have to fix what I get). On a second sheet I have a master column of all correctly spelled locations. My goal is to search the City/State column and compare to the master column and for any value found that is not in the master column (i.e., a misspelling), fix it. Before tackling how to fix problems found, I am trying to just find the misspelled cells and write the misspelling and row number somewhere. I'm just learning VBA so after searching and finding many different solutions, I tried to adapt the few I could actually understand. But I get a type mismatch in the "itemfound = ..." line.
I suspect this should be easy to figure out, but I'm stumped. Honestly, I understand most of what is going on here, but the bit I don't has hindered my ability to figure it out.
Thanks for any direction.
Please Login or Register to view this content.
Bookmarks