Luke,
The first one works great (thanks) but by counting line feeds (Chr(10)) it does not recognize the number of lines created by automatically wrapping text within a cell. Is there any way of determining the number of lines resulting in a cell with "wrap text"?
Thanks!
I'm looking for a way (probably a macro) to automatically adjust row height based upon the number of lines in a specified range of columns. Specifically, for a specified range of rows, I would like to adjust the row height of each row to be (the maximum number of lines of text in columns B thru...