Type Mismatch when checking spelling on range - but only if a 'magic number' is exceeded.

[staggers47]

Hi, I have a a cell (actually 28 cells merged into a block) for a user to type a few sentences in.

Before anything else, a spell check is done, using the line below.

Please Login or Register  to view this content.

ChkSpell is Boolean, BTW.

This has always been fine. But the sentences have been getting longer, and suddenly, when all but the last line of the text box was full, it bounced out with a 'Type Mismatch' error, and the above line highlighted. This happened at around 45 words or so.

When I commented out the spell check, I was able to fill the box and continue the routine without a problem.

Is there some sort of magic limit? Or is there somewhere else I should look for the answer?
Any help on this issue would be much appreciated. It isn't the end of the world, but I certainly didn't expect to come up against it!

Thanks.

[OllieB]

Funny. The help text in Excel 2010 states that you can check the spelling of a single word using this instruction. Nothing about sentences etc. There is however an alternative that may be more suitable to your needs

Please Login or Register  to view this content.

[staggers47]

Hi Ollie.

I'm afraid that doesn't help at all! For two reasons:

1. It offers solutions to every misspelling it finds.
2. It checks the entire worksheet.

The one I used above was simply a Boolean that will check spelling, and give False if there's an error, so I can take whatever action is needed. Also, it only checked the (merged) cells. I didn't know it was only supposed to check a single word. Seems like it can do more, but up to around 45 words or so!

So what I need then is a Boolean version of the spellcheck that will just check that one merged cell, and give true or false at the end. And do more than 45 words!

Regards.

[OllieB]

In my test it just checks the contents of the range object and NOT the remainder of the worksheet. If you are only interested in True/False then this is not the answer for you.

[staggers47]

Hi,

I just checked it again, and for reasons I can't begin to understand, it checks other parts of the sheet first, and then eventually gets to the range it's supposed to check. I cannot understand it at all. However, be that as it may, it doesn't do what I need, so I've had to revert back to the previous way while I try to find another answer, because that does work, even if there's a limit!

Regards.

[staggers47]

Just a test to see if I can post by replying to one of my own. Have been unable to post ever since the server problems. Please ignore.

[staggers47]

So, I can reply to a post of my own, but I can't start a new thread (get 403s when I try). How odd. If anyone happens to read this could they get a mod to see if my account is ok, since I can't start a new thread!

[staggers47]

I'm sorry everyone to mark this as unsolved again, but hijacking my own thread is the only way I can post anything and get the attention of admins; emails have not been answered either.

So if anyone sees this I'd be grateful if they could get an admin to look into the problem!

Thanks.

[JosephP]

there don't appear to be any problems with your account settings-perhaps you could try clearing your internet cache and then log back in and try posting a new thread?

[staggers47]

Hi Joseph. Thanks for replying. Clearing the cache was the first thing I did. This problem started same time as your server problems did. I can go to any site, log in, do whatever I need. Except here I can do everything except post! I've used different browsers, too, and so far without result. I can compose a message without a problem. But, the minute I hit the post button, i get taken to a blank page (in FF), or a blank page with a 403 error in Chrome. I'm currently stumped as to what to do next, so any suggestions will be much appreciated!

Again, sorry to use this thread for this purpose, but it's the only thing I can reach at the moment.

[JosephP]

I've escalated the issue to a higher authority-will keep you updated ;-)

[staggers47]

OK, thank you.

[JBeaucaire]

The tech team has been alerted. Sorry for the inconvenience.

[JosephP]

can you try posting a new thread now?