ExcelBanter - Visual basic excel application

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Visual basic excel application (https://www.excelbanter.com/excel-programming/346414-visual-basic-excel-application.html)

WilliamMomo

Visual basic excel application

How can I auto resize a column to fit the length of a cell's content using
the Excel Application object

Bob Phillips[_6_]

Visual basic excel application

Columns("C:C").Autofit

--

HTH

RP
(remove nothere from the email address if mailing direct)

"WilliamMomo" wrote in message
...
How can I auto resize a column to fit the length of a cell's content using
the Excel Application object

Don Guillett[_4_]

Visual basic excel application

is this what you wantWorksheets("Sheet1").Range("A1:E1").Columns.Au toFit--
Don Guillett
SalesAid Software

"WilliamMomo" wrote in message
...
How can I auto resize a column to fit the length of a cell's content using
the Excel Application object

All times are GMT +1. The time now is 03:26 PM.