URGENT--setting width of column in excel throgh code+vb

[chetan_agarwal]

Hi All, I want to set the width of column of excel while generating excel through code(on button click) in VB application.Any one knows how to do it...!!!!!!

[Dalek Dave]

Columns("C:C").Select
Selection.ColumnWidth = 17.71

Obviously where I have set the specified columns as "C:C" you could set as (Col1:Col2), and where I have put in a set column width you could have a variable. I hope this helps.

------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave