Column Width Problem

[ietprofessional]

I'm currently trying to export some table data to an Excel file. The problem is that the data columns in the Excel sheet is not expanded to the width of the text.

Can anyone suggest anything?

Thank You!

 

[DanJR]

well, if you are using the excel object model then you could use the AutoFit method e.g.

Columns("A:C").AutoFit

or you can set the column width by:

Columns("A:C").ColumnWidth = 14.14

same is true for rows.

see the help file for more info.
cheers,
dan