+ Reply to Thread
Results 1 to 5 of 5

VBA Spell Check

  1. #1
    Registered User
    Join Date
    10-09-2017
    Location
    London, England
    MS-Off Ver
    2011
    Posts
    2

    VBA Spell Check

    Hi!

    I have an excel spreadsheet with around 10,000 cells in a single column which all contain 200-300 words of text and need spell checking. I am very new to VBA and Macros so found the following code online and simply pasted it into the Visual Basic Editor tool on Excel for Mac.

    Please Login or Register  to view this content.
    When I hit run it returns a "Run-time error '13': Type mismatch" message.

    Could anyone help/tell me what I am doing wrong?

    Thanks!
    Last edited by jwamawatts; 10-09-2017 at 12:11 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: VBA Spell Check

    Welcome to the board.

    Please take a few minutes to read the Forum Rules, and then edit your post to wrap your code with CODE tags.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: VBA Spell Check

    Thank you.

    Works fine for me on Windows. I've never touched a Mac.

  4. #4
    Registered User
    Join Date
    10-09-2017
    Location
    London, England
    MS-Off Ver
    2011
    Posts
    2

    Re: VBA Spell Check

    So I played around with it a bit more and like you say, the code works perfectly but only if the length of text in the cells isnt longer than 1 or 2 lines. The length of the text that I am trying to deal with seems to be where the problem is. Any thoughts on why this could be the case and/or how to fix it?

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: VBA Spell Check

    How about ignoring cells with more than 255 characters?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Changing Spell Check language of Vba Spell Checker
    By jhelliar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-09-2021, 03:51 AM
  2. Replies: 1
    Last Post: 10-20-2014, 11:01 AM
  3. Spell Check and Grammar check in Particular Column
    By dhilipan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-16-2013, 06:35 PM
  4. VBA Spell Check - Dont ask to check rest of Doc?
    By Chris424 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-03-2008, 07:42 AM
  5. Spell Check
    By khanjee in forum Excel General
    Replies: 2
    Last Post: 02-22-2008, 04:44 AM
  6. [SOLVED] Spell check
    By Tonks in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2006, 06:48 AM
  7. [SOLVED] Spell Check
    By Hans Emilio in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-12-2005, 05:05 PM

Tags for this Thread

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