Take a look at the macro by Jim Rech:


http://groups-beta.google.com/group/...programming/br
owse_frm/thread/c681ec7915bee300/2601d8ed556c55e9?


In article ,
Joanne (JAS) <Joanne wrote:

I have merged two cells and want it to expand (get bigger) as more text is
typed or added.

I'm able to do this with just a single cell (row autofit, wrap text), but
when I merge two or more cells, these options no longer work.