Spell Check

[akberali67]

Hi,

I have a list of cell with sentences. How do I auto-fix misspellings and Grammar using SpellCheck in Excel 2010 using VBA. I mean I can find the words easily using VBA but how to make it change all and ignore if no suggestions. When recording the macro, it is not recording that bit.

Please help!

Thanks,
Akber.

[xladept]

Hi akberali67,

There is a CheckSpelling Method in help for VBA.

[akberali67]

Ok but what I was looking for is how to make vba pick the first suggestion and ignore if there is no suggestion.

I know how to make vba pull up the spell check but how do you make it pick the first selection and ignore when there are no suggestions?

[xladept]

Here's some code that worked for me:

Please Login or Register  to view this content.

[akberali67]

Hi,

I can use that as an exit if no suggestions are available but how do I get the code to select the first suggestion from the dictionary?

-Akber.

[xladept]

This is what I've used:

Please Login or Register  to view this content.