Macro crashes excel after spell check is ran.

**dasani9999** · 02-04-2013, 04:05 PM

I have created a macro that will take text entered into a cell and parse it out into adjoining cells. The macro works fine until I run spell check. Once I run spell check, if there are couple of spelling errors in multiple cells in the column the macro is watching, it will cause excel to crash. Is there any way to keep the macro from running on spell check changes? Any help with this would be appreciated.

**ragavan.sridar1** · 02-04-2013, 04:47 PM

Can you post you code??

**dasani9999** · 02-04-2013, 05:39 PM

This is an abridged version of the code:

Sub Worksheet(ByVal Target As Range)
Set Keycalls = Range("I:I")

If Not application.Intersect(KeyCalls, Range(Target.Address)) _
Is Nothing And Firsttime = 0 Then
Firsttime = 1
Anchor0 = "I" + Mid(Target.address, 4, 9999)
Anchor1 = "J" + Mid(Target.address, 4, 9999)
Alltext = ""
Alltext = Range(Anchor0)
If Len(Alltext) > 250 _
Then
partA = Mid(Alltext, 1, 250)
partB = Mid(Alltext, 251, 250)
Else
partA = Alltext
End If
Range(Anchor0) = partA
Range(Anchor1) = partB
Firsttime = 0
End If
End Sub