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!

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.

Thank you.

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

How about ignoring cells with more than 255 characters?