Thanks, that was what I needed.
>>My mind has gone blank. How can I set the width of an Excel Column through Automation?
>
>You have to set the width of a cell. The following is from one of my programs:
>
>
>with oSheet
> .Cells(1,1).ColumnWidth = 6
> .Cells(1,2).ColumnWidth = 30
> ...
>endwith
>
>
>The above example sets the ColumnWidth of columns A and B. I prefer the RC (row-column) syntax, because it is easier to manipulate numbers than letters for columns.
Fred Lauckner
You know, it works on my computer. I don't know what your problem is.
.Net aint so bad.
