CheckSpelling Method Continues beyond specified range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sometimes when code like that below is executed, the Checkspelling method
continues checking spelling for the rest of the worksheet after it finishes
with the specified range. There is no notification between completion of
checking of the specified range and continuation beyond the named range.

Range("Discussion2").CheckSpelling

When the same code structure is applied to some ranges, the "overrun"
occurs, while for other ranges it does not.
 
Try adding the "SpellLang" argument and see if that helps...

Range("Discussion2").CheckSpelling(SpellLang:=msoLanguageIDEnglishUS)

Jim Cone
San Francisco, CA
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Check Spelling doesn't highlight misspelled word 5
Spellcheck a single cell 11
spellchecking only the unlocked cells of a protected spreadsheet? 5
Pasted text will not spell check 5
spell check ranges in a do loop 2
CheckSpelling a Textbox 5
spellLang # for UK 2
Spell checking textbox on a userform 10

Back
Top