Big Crash

[Paul_Hossler]

Would something like that if run through on various attempts be enough to cause a crash?

This is Excel so it's hard to say

However, I've had good luck with ...

http://www.appspro.com/Utilities/CodeCleaner.htm

The Excel VBA Code Cleaner

During the process of creating VBA programs a lot of junk code builds up in your files. If you don't clean your files periodically you will begin to experience strange problems caused by this extra baggage. Cleaning a project involves exporting the contents of all its VBComponents to text files, deleting the components and then importing the components back from the text files.

Unfortunately it only works with 32 bit Excel, but you can still manually export modules and then import them (I think) since that seems to be how the cleaning function works

I have seen examples of code where the dot occurs in more than one place on a line, always referencing back to the with command

Option Explicit

Sub test()
    With Worksheets("Sheet1")
        With .Cells(1, 1)
            MsgBox .Address
            With .Interior
                MsgBox .ColorIndex
            End With
        End With
    
        With .Shapes(1)
            MsgBox .Name
        End With
    
        MsgBox .Name
    
    End With
End Sub

[garyj]

Also, Paul.. mine is 64bit, but I followed that link anyway and read it through. That is basically what I did.
Thanks