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

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

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

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!