VBA Spell Check

**jwamawatts** · 10-09-2017, 11:55 AM

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!

**shg** · 10-09-2017, 12:07 PM

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.

**shg** · 10-09-2017, 12:14 PM

Thank you.

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

**jwamawatts** · 10-09-2017, 12:40 PM

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?

**shg** · 10-09-2017, 12:46 PM

How about ignoring cells with more than 255 characters?

VBA Spell Check

LinkBack

Thread Tools

Rate This Thread

Display

VBA Spell Check

Re: VBA Spell Check

Re: VBA Spell Check

Re: VBA Spell Check

Re: VBA Spell Check

Thread Information

Users Browsing this Thread

Similar Threads

Changing Spell Check language of Vba Spell Checker

How to detect Spell Check activated - or - exit sub when you press cancel on Spell Check

Spell Check and Grammar check in Particular Column

VBA Spell Check - Dont ask to check rest of Doc?

Spell Check

[SOLVED] Spell check

Spell Check

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions