When you apply the CheckSpelling method to a one-cell range, Excel continues to check the rest of the sheet and prompts you to continue spellchecking from the beginning of the sheet. You can use
Application.DisplayAlerts = False to remove the prompt, but it still checks more than just that cell.
‘Checking one cell will result in a prompt
Tom Ogilvy noted in a recent newsgroup post that extending the range to more than one cell solves both problems.
‘this eliminates the prompt, but still checks D4
Application.DisplayAlerts = False
Application.DisplayAlerts = True
‘This checks c3 only – kind of
Union, the range in question with a cell that we know to be empty (IV65536 in this case) limits the spellcheck to one cell – actually two, but who’s counting.