Clear merged and non-merged cells in named range.

Preumably with a VBA macro line

Please Login or Register  to view this content.

When you've done that I suggest you unmerge all the cells. Most of us avoid them like the plague since they just cause too many problems with various aspects of Excel & VBA.

Doing a single cell and letting the text spill over seems to be working fine thus far but I still have 3 merged cells which must be dealt with in order to display things properly.

Update again: "Center across selection" after selecting multiple cells and formatting them solved my alignment concern without merged cells however this cannot apply to a block of merged cells required for further text.

I have changed these "notes" sections to textboxes instead. Problem sorted.

For anyone else stumbling across this thread, note that .Clear removes formatting of cells on a worksheet and .Clearcontents removes only the cells.. well, contents.

Update again: "Center across selection" merges all neighboring cells with this value set, even if they are selected and set independently. Need another cell between the selections to prevent this.