CheckSpelling

[lezawang]

Hi
the code below check the spelling but I noticed that excel will not see a word has wrong spelling if it has number. Is that by design? for example, excel wont give error spelling if the word like this

teest1
ttest1
testtttt1

but without number one, all above words will be checked for spelling.

Sub cells_spelling()
    Workbooks(1).Worksheets(1).Cells.CheckSpelling
End Sub

 

[Michael M]

excel will not see a word has wrong spelling if it has number

You can change the settings for Excel to allow for this...there are a number of other options you can look at here



https://www.ablebits.com/office-addins-blog/2018/08/15/spell-check-excel/