spell check does not visually cycle through cells when run from macro?

[Dan]

I'm trying to recreate the same behavior in a macro that spellcheck has when
the spellcheck button is pressed. The spellcheck does not cycle through the
cells visually when run from a macro, so when there is a misspelled word,
you cannot see the cell it is a part of.

If anyone knows how I can get this behavior to work, it would be GREATLY
appreciated.

I did a record new macro, and got code similar to the following:
Sub testSpelling()
Range("F2:F500").Select
Selection.CheckSpelling SpellLang:=1033
End Sub

thanks, dan

 

[SOS]

Dan,

Add the fiollowing to your code as shown:

, AlwaysSuggest:=True


Sub testSpelling()
Range("F2:F500").Select
Selection.CheckSpelling SpellLang:=1033, AlwaysSuggest:=True
End Sub

I tried it and it brought the SpellCheck Dialog box to the scree
asking to change the offending word to the correct spelling.

Regards

Seamu

 

[Dan]

I can see the dialog box fine, my issue is that if a range of cells are
selected to check the spelling in, you can't tell which cell the current
misspelled word is in because it doesn't get highlighted when you run the
spellcheck from a macro. This behavior is different than if you select a
range of cells and press the spellcheck button(then you can see which cell
the current misspelled word is in).
thanks, dan

 

[nickbike]

I was searching around looking for the answer to this same question.
can't see the cells that the spell checker is currently checking i
those cells were off the page when the spell checker started.

I am simply using this:

Sheets(2).Activate
Cells.CheckSpelling

What do I need to add?

Thanks,

Nic