error in auto fit
Posted by David on July 06, 2001 8:11 AM
Worksheets("Data").Cells(5, x).Select
Worksheets("Data").Cells(5, x).Columns.AutoFit
Worksheets("Data").Cells(5, x).ColumnWidth = Worksheets("Data").Cells(5, x).ColumnWidth + 2
this is in a loop
how do I do this without selecting the columns
in other word I want every column to be auto fit then ad 2 to it without sellecting any columns