ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   CheckSpelling Method Continues beyond specified range (https://www.excelbanter.com/excel-programming/314333-checkspelling-method-continues-beyond-specified-range.html)

greggmendel

CheckSpelling Method Continues beyond specified range
 
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.

Jim Cone

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.



All times are GMT +1. The time now is 02:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com