rows of text in merged cell with wrap text

[Guest]

Hello.

Is there a way to determine the number of rows of text displayed in a cell
with the wrap text property turned on?

I was thinking of other ways to get multiple rows... alt-enter , and I think
if you take the string of that and count the char(10) count, you could get
that.

But is there a way to do it on wrapped text?

Thanks,
Mark

 

[Tim Williams]

No idea how to do this directly.

One way might be to copy the cell to an empty worksheet, (set the column width the same) and then turn wrapping off and compare
the 2 row heights. Works OK if the text size is not too small...

Tim.