Hi Ken,

You have basically answered your own question. "if you enlarge the column
width larger than a single item in the list, then it wraps at the vbLf".
Simply set the column width larger than what can be expected and then apply
AutoFit.

Even in the interactive mode you have to widen the column and then apply
AutoFit or it adjusts to the widest existing data in the cells and tends to
ignore linefeeds. Auto column width adjusts to the max width of the data in
the cells as it exists prior to the AutoFit.

A little constructive criticism on your other code. Why loop trough the used
range to adjust the height. You can simply apply Autofit to the entire used
range.

objSheet.UsedRange.Rows.AutoFit

'or following

With objSheet.UsedRange
.Rows.AutoFit
.Columns.AutoFit '(If required.)
End With

--
Regards,

OssieMac