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

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

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

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

On Sun, 13 Nov 2011 06:56:20 -0800 (PST), geniusideas
wrote:

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