Formatting Cell Max. Size in Marco

[GoodmanJim]

Using Excel 2007 - In a macro to set the row height to cell size (Selection.Rows.AutoFit) the row does not open to display the total words in a cell. It will open to a max. value of 141.75. The row height is a variable besed on it's content.

Is this anyway to open the row or cell to a greater value still keeping it a variable height?

Thanks in advance for your help