>Hi,
>
>Does any one know how to change the size (Length) of cells in Excel using remote objects? Help on MSDN talks more about the VB.
You can't change the width of an individual cell, only of a column.
Sample code:
with This.oSheet
.Cells(1,1).ColumnWidth = 6
.Cells(1,2).ColumnWidth = 30
.Cells(1,3).ColumnWidth = 8
.Cells(1,4).ColumnWidth = 30
.Cells(1,5).ColumnWidth = 7
.Cells(1,6).ColumnWidth = 9
.Cells(1,7).ColumnWidth = 10
.Cells(1,8).ColumnWidth = 13
.Cells(1,9).ColumnWidth = 9
endwith
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
