Thread: How to make rows autofit when cells merge and multi line text inside
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
  
Posts: 621
Default 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
Reply With QuoteReply With Quote