I have the following worksheet change event script:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

If Target = Range("c35") Then

    Application.EnableEvents = False

        Range("m35").Value = ""
        Range("c37").Value = ""

    Application.EnableEvents = True

End If

End Sub


Any time I delete the contents of a cell that is within a merged range of cells, I get a Runtime Error #13. Can anyone explain this and how to avoid it?

Thanks,

Bryan Brassell



Bryan A. Brassell

Bryan:

When you try to put data into merged cells on the spreadsheet itself, you will find you can only address one of the cells. (Try an example: merge A1,B1 and C1: then try to put data into B1!)

I suggest that you unmerge the cells: put your new data in: then remerge them. If the code eludes you, a macro recording will point you down the road.

Alf