VBA to Relocate & Resize merge cells with text

[ALAMZEB]

Hi
I am unsuccessful in generated macros that will relocate and resize Comment box (merge cells) to different position if B119 is anything but “SELECT TYPE”
Attached below will give you clear picture

 

[Luke M]

VBA & Merged cells do not play nicely together. IMO, it's better to avoid merged cells altogether as they cause many problems with sorting, filtering, VB, etc.

In your case, do we need to transfer the coloring of cells, or just the contents?

 

[ALAMZEB]

Hi Luke

The color is same for both location. I am using Light blue template. attached below is the exact color of template
Once again thanks for helping out.

 

[Luke M]

Here's how I would do it. Uses a simple formula and some conditional formatting, rather than having to use a macro.

 

[ALAMZEB]

Thanks luke