Macro to ignore merge cell message

You can wrap the code anywhere around the offending line - but it is safer always to wrap only lines triggering messages you will always want ignored.
What the code does is to suppress most warning pop-ups until the value is set to true.

You can safely wrap it around all lines involved in merging or unmerging - but I would not wrap code doing anything else.

To avoid using merged cells - locate text boxes above the cells and pull values into text boxes from the cells underneath
- when making things pretty gets in the way of functionality I leave things ugly every time