rows of text in merged cell with wrap text

M

mark

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
 
T

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top