Spell check macro not working :(

I'm trying to set up a spell check macro for a specific range in column I.

I've come up with this, but Excel gives me an error. Can someone help me fix it? PLEASE HELP!!!

Please Login or Register  to view this content.

Thank you!

Originally Posted by shg

What's the End If doing in there?

Whoops! I was testing something out (which clearly didn't work).

So … the code is now as follows. But it still doesn't work!

Please Login or Register  to view this content.

Any suggestions?

This is the error I get:

Screen Shot 2013-03-03 at 2.48.00 AM.jpg

Originally Posted by shg

Please Login or Register  to view this content.

Thanks for the help, but this is what I get when I tried your suggestion:
Screen Shot 2013-03-03 at 2.56.13 AM.jpg

And then:
Screen Shot 2013-03-03 at 2.56.31 AM.jpg

Originally Posted by shg

EDIT: I don't understand that error -- it works for me exactly as posted. Can someone else try?

EDIT2: For readability, I would use the language enumeration instead of the inscrutable literal:

Please Login or Register  to view this content.

The error seems to be something wrong with the language selection. If I take out the SpellLang specification it works (and defaults to USA English). Is there any reason why it doesn't work with AUS English?

P.S. I tried both SpellLang types … the number and the wording.

This problem is solved here: http://www.excelforum.com/excel-prog...html?p=3144136