View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Alternative Ways to Spellcheck a Range

Hi Jay,

Are there any other ways to perform a spell check on a range, other
then saying myRange.CheckSpelling(...)? Like maybe call the F7
Spellcheck function on a range somehow (this is different then the
range.CheckSpelling function).


Calling Spellcheck from Excel, either using F7 or the menu option, invokes
the CheckSpelling method. The only difference is that Excel always uses the
current values for the optional CustomDictionary, IgnoreUppercase,
AlwaysSuggest and SpellLang parameters. whereas invoking the method from VBA
enables these settings to be modified.


---
Regards,
Norman