autofit with wrap

[joemeshuggah]

is it possible to program via vba a means to autofit column that has a
wrapped cell in the header where the column width is based on the longest
contiguous string of characters within the cell?

 

[JLGWhiz]

Autofit will find the best fit for the text that is entered. It is not
based the length of a string.