| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i wrap text in a merged cell in excell?
i wish to merge some cells using VBA, add text then wrap the text so the
merged cell will get taller if the text wont fit in it. only the wrapping isnt working. i have the row height set to auto and it works when the cells are not merged. it is important that i merge them |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do i wrap text in a merged cell in excell?
Hi Smithy,
See this macro from Jim Rech http://tinyurl.com/4c5l6 --- Regards, Norman "Smithy" wrote in message ... i wish to merge some cells using VBA, add text then wrap the text so the merged cell will get taller if the text wont fit in it. only the wrapping isnt working. i have the row height set to auto and it works when the cells are not merged. it is important that i merge them |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do i wrap text in a merged cell in excell?
Smithy,
I played around with this, and you are right auto fit doesn't work :( I recommend manually adjusting '.RowHeight' based on the length of the cell's value; I.E. Len(Cell(1,1)). This will be a bit of trial and error based on the column widths involved. HTH, Lonnie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wrap Text doesn't work in Merged Cell | Excel Discussion (Misc queries) | |||
| Merged cell text does not wrap | Excel Discussion (Misc queries) | |||
| How do I view all text in a merged cell? Wrap text is activated. | Excel Discussion (Misc queries) | |||
| Can you get a Merged Cell with Text Wrap to Autofit? | Excel Programming | |||
| Can you get a Merged Cell with Text Wrap to Autofit? | Excel Programming | |||
Linear Mode
