RE: Excel Automation how do I resize a column? 1

[AaronA]

I am trying to do some Excel Automation. I need to be able to change the width of a column in the Excel Workbook. Any Ideas on how to do that? I have tried this:

Workbook.Range("A1&quot.Width = 12

do you see what I am trying to do? It tells me something about an object is required, but I am trying to set a number, not an object. I have also tried using the column property, but gives an error as well. Hope someone can help. Thanks

 

[JohnYingling]

Application.Columns("A:A&quot.ColumnWidth = 12

Hint: Tools / Macro / Record New Macro
move column 1 border
Stop record
Tools / Macro / Macros / select / Edit
Look at generated code

http://WWW.VBCompare.Com