| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Increase columns with interop
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Increase columns with interop
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Increase columns with interop
Nick,
great! Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I increase the number of columns in excel above 256 | Excel Discussion (Misc queries) | |||
| increase the number of columns from 256 to 365 | Excel Discussion (Misc queries) | |||
| Could you tell me how I increase more columns in Excel? | Excel Discussion (Misc queries) | |||
| increase # of columns | Excel Discussion (Misc queries) | |||
| how do i increase the number of columns in excel | Excel Programming | |||
Linear Mode
