Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Bar continues to move | Excel Discussion (Misc queries) | |||
Adding named range gives error "method range of object _Global failed " | Excel Programming | |||
CheckSpelling + TextBox | Excel Programming | |||
TextBox - CheckSpelling question | Excel Programming | |||
Application.CheckSpelling Error in Macro | Excel Programming |