View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default CheckSpelling Method Continues beyond specified range

Try adding the "SpellLang" argument and see if that helps...

Range("Discussion2").CheckSpelling(SpellLang:=msoL anguageIDEnglishUS)

Jim Cone
San Francisco, CA

"greggmendel" wrote in message ...
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.