| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
number of lines of wrapped text
I have a number of cells merged into one and has 'Wrap Text' set.
After typing text into the cell I want to know how many lines of text is in the merged set of cells so I can automatically resize it. Is there a way to do this. Thanks, Fred |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
number of lines of wrapped text
Hi Fred,
See a routine posted by Jim Rech to autofit row heights on merged cells http://tinyurl.com/4c5l6 --- Regards, Norman "Fred" wrote in message ... I have a number of cells merged into one and has 'Wrap Text' set. After typing text into the cell I want to know how many lines of text is in the merged set of cells so I can automatically resize it. Is there a way to do this. Thanks, Fred |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
number of lines of wrapped text
Thanks Norman
"Norman Jones" wrote in message ... Hi Fred, See a routine posted by Jim Rech to autofit row heights on merged cells http://tinyurl.com/4c5l6 --- Regards, Norman "Fred" wrote in message ... I have a number of cells merged into one and has 'Wrap Text' set. After typing text into the cell I want to know how many lines of text is in the merged set of cells so I can automatically resize it. Is there a way to do this. Thanks, Fred |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to split wrapped text in a single cell into multiple lines | Excel Discussion (Misc queries) | |||
| Wrapped text stops wrapping after 8 lines in MS Exel. How to fix? | Excel Discussion (Misc queries) | |||
| How can I get excel to show ALL lines of wrapped text? | Excel Worksheet Functions | |||
| How to adjust spacing between lines of wrapped text ? | Excel Discussion (Misc queries) | |||
![Fred[_22_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
