How to make rows autofit when cells merge and multi line text inside

[geniusideas]

Hi,

In my project i need to fit row size accordingly, but the problem now
autofit not working when cells is merge and some-more inside this
cells contain multi line text (Next line with Alt+enter). Any one
here got idea how to do it? Most probably I need VBA code to do it.
Immediate reply much more appreciated.Thanks

 

[Gord Dibben]

You need event code to autofit the wrapped text in merged cells.

Just one of the many benefits of the evil merge cells<g>

See google search thread for code by Greg Wilson.

http://tinyurl.com/27qe7ql


Gord