Clear contents of merged cells

[Paella1]

Is there a clever way to clear the contents of merged cells without getting "Cannot change part of a merged cell" ?

The only way I can get it to work is by selecting the cell. This offends the coding gods.

 

[wut]

Target the entire range.

 

[chuckchuckit]

Or possibly use ClearContents instead of Clear.

 

[wut]

Every method will fail unless you target the whole range. There's nothing wrong with changing a merged range; it's part of a merged cell you can't change

 

[Paella1]

The "target" is an offset from a cell that has been changed (the procedure is event triggered, so target is an unfortunate choice of terminology). It may or may not be part of merged range. I am trying to think of a way that will target the entire range if the "target" is merged.

 

[wut]

Will the merged ranges be different sizes?

 

[Ruddles]

You can do this on any part of a merged cell:-

Range([I]whatever[/I]).MergeArea.ClearContents

 

[Paella1]

Ruddles, that is magnificent! I shall have your post embroidered on fine lace so I may pass it on to my grandchildren.

 

[Ruddles]

I got it from my own dear grandmother in a very similar sort of way!