Export (0) Print
Expand All

Range.CheckSpelling Method

Office 2007
Checks the spelling of an object.

Syntax

expression.CheckSpelling(CustomDictionary, IgnoreUppercase, AlwaysSuggest, SpellLang)

expression   A variable that represents a Range object.

Parameters

NameRequired/OptionalData TypeDescription
CustomDictionaryOptionalVariantA string that indicates the file name of the custom dictionary to be examined if the word isn't found in the main dictionary. If this argument is omitted, the currently specified dictionary is used.
IgnoreUppercaseOptionalVariantTrue to have Microsoft Excel ignore words that are all uppercase. False to have Microsoft Excel check words that are all uppercase. If this argument is omitted, the current setting will be used.
AlwaysSuggestOptionalVariantTrue to have Microsoft Excel display a list of suggested alternate spellings when an incorrect spelling is found. False to have Microsoft Excel wait for you to input the correct spelling. If this argument is omitted, the current setting will be used.
SpellLangOptionalVariantThe language of the dictionary being used. Can be one of the MsoLanguageID values used by the LanguageID property.

Return Value
Variant

Remarks

This method has no return value; Microsoft Excel displays the Spelling dialog box.

To check headers, footers, and objects on a worksheet, use this method on a Worksheet object.

To check only cells and notes, use this method with the object returned by the Cells property.




Community Additions

ADD
Show:
© 2014 Microsoft