Tim,
Look at the .Autofit property.
Columns("A:A").EntireColumn.AutoFit

It's easy to record a macro in Excel then translate the code. To VB.Net in
your case.

NickHK

"Tim Lypes" wrote in message
...
Hello,
I write an VB 2005 application that fills data into an excel spreadsheet
with office.interop.
Now I wanted to ask if it is possible to increase the column width to the
highest text value. Maybe you know that effect if you double click the
line
between two excel columns and the width increase automatically.

Can anybody help to find the right function?