Results 1 to 5 of 5

VBA Spell Check

Threaded View

  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.

    Sub ColorMispelledCells()
    For Each cl In ActiveSheet.UsedRange
    If Not Application.CheckSpelling(Word:=cl.Text) Then _
    cl.Interior.ColorIndex = 28
    Next cl
    End Sub
    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.

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. 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