Chris

That's how row>autofit and wrap text work.

Add more text, row adjusts height to fit as long as wrap text is enabled.

If you set all the cells in the row to autofit and wrap text, the cell with the
most text will govern the row height.

BTW: row heights are generally measured in points...............72 points to the
inch.

12.75 points won't show much text unless you have a very wide column.

You could use event code to adjust the row heights to a specific size based upon
string length of a cell.

Something like this.......................

Private Sub Worksheet_Change(ByVal Target As Range)
   Dim rng As Range
   Dim vRngInput As Range
   Set vRngInput = Intersect(Target, Range("B:B"))
   n = Target.Row
   If vRngInput Is Nothing Then Exit Sub
   On Error GoTo endit
   Application.EnableEvents = False
       For Each rng In vRngInput

           Select Case Len(rng)
               Case Is <= 200: Num = 12.75
               Case Is <= 400: Num = 25.5
               Case Is <= 600: Num = 39.25
               Case Is > 600: Num = 53.25
           End Select

           Excel.Range("B" & n).RowHeight = Num

       Next rng
endit:
       Application.EnableEvents = True
End Sub

Gord