VBA Code to highlight cells with spelling mistakes

**gmason234** · 09-24-2015, 11:29 AM

Hi all,

I signed up to this forum because I need your help!

I have a large export which contains just under 60,000 rows. Unfortunately, the exported data has various spelling mistakes in column D.

Each cell contains up to 250 words and I would like to know whether any word within a cell has been misspelt, If they have I would like to highlight this cell. Obviously it would be better if it pulled across the word that has been misspelt, but that must be complex.. right?

Any help/advice would be great!

Cheers,

George

**gmason234** · 09-25-2015, 11:10 AM

I have found a fix, this code highlights the cell in yellow and word in red, just in case anyone requires this code in the future, please see below:

Please Login or Register  to view this content.

VBA Code to highlight cells with spelling mistakes

LinkBack

Thread Tools

Rate This Thread

Display

VBA Code to highlight cells with spelling mistakes

Re: VBA Code to highlight cells with spelling mistakes

Thread Information

Users Browsing this Thread

Similar Threads

Highlight Cells with Spelling Error

Help! Advanced vlookup solution when dealing with typing errors and spelling mistakes

Code to compare if values in two cells are the same, if yes highlight both cells green

[SOLVED] Code to Highlight Cells

[SOLVED] Count unique text and finding spelling mistakes

Highlight Row - Limit the code to certain cells

Protecting Cells and being able to use Spelling Function

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions