USD$30 - auto generated email with specific fields, outlook 2010

Re: USD$30 - auto generated email with specific fields, outlook 2010

Quote from steve400243;786668

Hello John, Here is the completed sheet, when i try to format Column H it stretches everything out and makes column H very wide? Any Idea why this wood be happening now?

Run this on the sheet and view the VBA Immediate Window.

Sub ColH()
    Dim r As Long
    For r = 1 To ActiveSheet.Cells(Rows.Count, "H").End(xlUp).Row
        Debug.Print ActiveSheet.Cells(r, "H").Address, Len(ActiveSheet.Cells(r, "H").Value)
    Next
End Sub

H7 contains a 7236 character string!