Spellcheck failing to get called twice

[umeshbhadouria]

' MyRangeSpell.CheckSpelling line of code works for first not for second With Block

Please Login or Register  to view this content.

[kev_]

I had a cursory look at your code and there appears to be no structural difference between the 2 blocks.
Try this and report back:
Swap the 2 blocks around so that it spellchecks sheet "D" first.

[umeshbhadouria]

Thank you Kev, I have swapped the code and was facing the same issue. I just change the cell reference in one line of code under disability structure

Please Login or Register  to view this content.

and it works. The reference I mention was wrong.

Thank you again for your assistance which help me to think differently.

[kev_]

You are welcome

Also if your original question is answered please click on Thread Tools (top of thread) and mark thread as solved (keeps things tidy). But you can still ask further questions after that if you need some associated help.

Feel free to click on * to add reputation if you are happy with help given

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)