| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge Cells in a Row to one Cell and text is NOT in a line | Excel Discussion (Misc queries) | |||
| autofit text inside merged cells | Excel Discussion (Misc queries) | |||
| why does line not autofit to amount of text? | Excel Discussion (Misc queries) | |||
| Autofit in Merge Cells | Excel Programming | |||
| copy/paste excel to texteditor -> multi-line text cells gain unwanted double-quotes | Excel Discussion (Misc queries) | |||
Hybrid Mode
