+ Reply to Thread
Results 1 to 14 of 14

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

  1. #1
    Registered User
    Join Date
    12-07-2012
    Location
    London, England
    MS-Off Ver
    Office 2010
    Posts
    81

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

    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.

  2. #2
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Type Mismatch when checking spelling on range - but only if a 'magic number' is exceed

    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.
    If you like my contribution click the star icon!

  3. #3
    Registered User
    Join Date
    12-07-2012
    Location
    London, England
    MS-Off Ver
    Office 2010
    Posts
    81

    Re: Type Mismatch when checking spelling on range - but only if a 'magic number' is exceed

    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.

  4. #4
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Type Mismatch when checking spelling on range - but only if a 'magic number' is exceed

    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.

  5. #5
    Registered User
    Join Date
    12-07-2012
    Location
    London, England
    MS-Off Ver
    Office 2010
    Posts
    81

    Re: Type Mismatch when checking spelling on range - but only if a 'magic number' is exceed

    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.

  6. #6
    Registered User
    Join Date
    12-07-2012
    Location
    London, England
    MS-Off Ver
    Office 2010
    Posts
    81

    Re: Type Mismatch when checking spelling on range - but only if a 'magic number' is exceed

    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.

  7. #7
    Registered User
    Join Date
    12-07-2012
    Location
    London, England
    MS-Off Ver
    Office 2010
    Posts
    81

    Re: Type Mismatch when checking spelling on range - but only if a 'magic number' is exceed

    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!

  8. #8
    Registered User
    Join Date
    12-07-2012
    Location
    London, England
    MS-Off Ver
    Office 2010
    Posts
    81

    Re: Type Mismatch when checking spelling on range - but only if a 'magic number' is exceed

    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.

  9. #9
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Type Mismatch when checking spelling on range - but only if a 'magic number' is exceed

    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?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  10. #10
    Registered User
    Join Date
    12-07-2012
    Location
    London, England
    MS-Off Ver
    Office 2010
    Posts
    81

    Re: Type Mismatch when checking spelling on range - but only if a 'magic number' is exceed

    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.

  11. #11
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Type Mismatch when checking spelling on range - but only if a 'magic number' is exceed

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

  12. #12
    Registered User
    Join Date
    12-07-2012
    Location
    London, England
    MS-Off Ver
    Office 2010
    Posts
    81

    Re: Type Mismatch when checking spelling on range - but only if a 'magic number' is exceed

    OK, thank you.

  13. #13
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Type Mismatch when checking spelling on range - but only if a 'magic number' is exceed

    The tech team has been alerted. Sorry for the inconvenience.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  14. #14
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Type Mismatch when checking spelling on range - but only if a 'magic number' is exceed

    can you try posting a new thread now?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1