Text wrap riddle!

I know this is normally a straight forward task but I am having difficulty because of the following:

When formatting a cell, it is straight forward to wrap your text and the cell increases in size to suit the wrap.

Problem - when I try to wrap text in multiple cells that have been merged together, I have to resize the cells to see the wrapped text.

Question - Is it possible to create a macro or similar that will solve my problem and automatically size my merged cells to view all wrapped text????

PLEASE HELP!!!!!

Many thanks

Kevin

Hi,
are you using merged cells only for formatting purposes or do you intend you use there content for analysis in the future?

Hi. I am only using them for formatting purposes! Hope this can help you help me.

Thanks