Spell Check range and move to active cells

[Jay]

Hello,

I'm calling the CheckSpelling function on a range, and it works fine
but I'd like it to move to the active cells as it find errors (like the
F7 spellcheck). How can I have the macro work in the same way? Is there
another spell check function in Excel I have to call other then the
CheckSpelling?

Thanks,
Jay

 

[Jay]

Is there maybe an argument that needs to be set that will dislay active
cells? Thanks

 

[Jay]

Looks like no one really knows yet. We'll if anyone ever does want to
know, i figured it out. Add the following line of code anytime before
you call the spell check:

Application.SpellingOptions.SuggestMainOnly = True

-Jay

 

[Jay]

Ok I don't know why that worked for one workbook, but it doesn't work
anymore. I thought maybe when that option was set, it called other
functions that said to show the active cell, but it doesn't (that was a
weird assumption anyway). So I'm still trying to figure out how to do
it...any ideas would help. Thanks!