Spell Check only Cell that has changed

[mowens74]

Hello,
I am trying to run a VBA to spell check a cell that has been changed and not the whole sheet. I have tried the following....

Please Login or Register  to view this content.

....and....

Please Login or Register  to view this content.

....but both check the whole sheet. I have also tried 'Cell.CheckSpelling' instead of 'Selection.CheckSpelling' in both sections but same issue.

Thank you.

[Marc L]

Hi !

Try replacing in first code Activecell by Target and Selection by Cell …

[mowens74]

Marc L: Just to confirm, I have changed the code to....

Please Login or Register  to view this content.

....but same issue, it checks the other cells.

[WideBoyDixon]

Please Login or Register  to view this content.

WBD

[mowens74]

Thanks WideBoyDixon but it still checks the rest of the document.

[WideBoyDixon]

Ah. A little research suggests that checking spelling on a single cell will check the whole sheet. Use a fixed cell that doesn't contain spelling errors and do it like this:

Please Login or Register  to view this content.

WBD

[mowens74]

WBD - thath works great, thank you.