AutoFit does only first cell of column

J

John

Columns("B").EntireColumn.AutoFit

This statement seems to take the first row of the column and fits to it. If
other cells of the column are wider i.e. their text is longer, they are
truncated. Is there a function which will look at all the cells in the
column and make the column width the width of the maximum cell width? Thanks
 
J

John

I'm sorry but this was posted to the wrong newsgroup.
It should be in microsoft.public.office.developer.vba
 
Top