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


"joemeshuggah" wrote in message
...
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?