Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Bar continues to move Kentle Excel Discussion (Misc queries) 0 November 2nd 06 02:33 PM
Adding named range gives error "method range of object _Global failed " Gunnar Johansson Excel Programming 3 August 10th 04 01:54 PM
CheckSpelling + TextBox Stuart[_5_] Excel Programming 0 July 27th 04 06:59 AM
TextBox - CheckSpelling question Stuart[_5_] Excel Programming 2 July 24th 04 08:41 PM
Application.CheckSpelling Error in Macro Bjorg P. Excel Programming 1 April 30th 04 10:30 PM


All times are GMT +1. The time now is 07:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"