Row Height Limit with AutoFit

J

JimS

I have a spreadsheet with a few hundred records that has a lot of tex
in one of the Columns.

I would like to limit (set a Maximum) that the Row Height can be befor
(or after) I use the Format, Row, AutoFit function.

This would allow AutoFit to appropriately size the rows with ver
little text while limiting the rows with a lot of text to only b
allowed to be so high.

Any ideas? I tried to use a "row.height <200", but it doesn't like th
less-then sign.

Thanks..
 
D

Don Guillett

something like
with range("whatever")
if .rowheight>200 then
.rowheight=200
else
..rowheight=
end with
 
Top