Spell Check range and move to active cells

  • Thread starter Thread starter Jay
  • Start date Start date
J

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
 
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Check Spelling doesn't highlight misspelled word 5
Spellcheck a single cell 11
VBA function to check if a string has valid spelling 3
Pasted text will not spell check 5
spell check ranges in a do loop 2
spellchecking only the unlocked cells of a protected spreadsheet? 5
textbox spell check 5
Spell checking textbox on a userform 10

Back
Top