Get Autofit in Excel to format just part of a column?

[Dlegrand]

Is it possible, using VBscript, to get Autofit to format only part of a
column when building an Excel spreadsheet?
--
David Legrand

[NickHK]

David,
No, the column can only have a single width.
But you can select which cell is used as the base for .AutoFit. e.g.

Range("A1").Value="This is long, long, long, long string"
Range("A2").Value="Short string"
Range("A2").Columns.AutoFit
gives a different column width to
Range("A1").Columns.AutoFit

NickHK

"Dlegrand" <[email protected]> wrote in message
news:[email protected]...
> Is it possible, using VBscript, to get Autofit to format only part of a
> column when building an Excel spreadsheet?
> --
> David Legrand