You have to reference all of the cells that are merged. In your example the
following should work...

Range("C1:D1").clearcontents

It's not enough to reference the first of the merged cells (which is
bothersome because in other instances, like copy, you can reference the first
of the merged cells only)

"ArthurJ" wrote:

I have merged cells C1 and D1, and named it 'mergedCells'.
But I get a "400" error from the following VBA code:

[mergedCells].ClearContents

That seems odd. Is there a workaround?

Art