In this video, I show you a VBA code that could save you a lot of time in checking the spelling on your spreadsheets. VBA Code Below:
Sub HighlightMisspelledCells()
Dim cl As Range
For Each cl In ActiveSheet.UsedRange
If Not Application.CheckSpelling(word:=cl.Text) Then
cl.Interior.Color = vbRed
End If
Next cl
End Sub
