Creating a Button That Clears A Merged Cell

[TroyDurham]

hello, Im creating a spreadsheet which will be used as a daily report for shift managers at my company. I have made a Macro to Reset (Clear) certain cells but one field is a merged cell. I get an error message saying that this operation cannot be performed on a Merged Cell, Is there anyway around this ?

[shg]

The answer is, don't merge cells.

If you search this forum for merged cells, you'll find one hundred other reasons not to.

[TroyDurham]

well its too late now

[Leith Ross]

Hello TroyDurham,

If you post your workbook, I can help you with this.

Sincerely,
Leith Ross

[TroyDurham]

Its Attached
Thanks

[Kenneth Hobson]

e.g.

Sub Test()
    ClearContentsRange Worksheets("FrontPage").Range("D9")
End Sub

Sub ClearContentsRange(someRange As Range)
    Dim ma As Range, tf As Boolean
    With someRange
        Set ma = someRange.MergeArea
        If .MergeCells Then
            tf = True
            ma.UnMerge
            .ClearContents
        End If
        .ClearContents
    End With
    If tf Then ma.Merge
End Sub