For Excel 2003, is there a way to determine the number of lines of text in a
cell (with wordwrap turned on? (Similar to LineCount for a textbox.)
I'm adding blocks of text to a cell, and--within limits--want to be able to
resize the cell so the whole block will be visible. The text may or may not
contain CR/LF characters, so there could be blank lines I'd like to have
displayed and included in the line count.
I'd prefer not to use autofit, so I can maintain a minimum rowheight, as
well as keeping from going over a maximum rowheight.
Thanks.
Bert