The entire column has a single width. However, you can join two cells horizontally; in that case, that part will be wider.
>Hi,
>Can I set the different cell width in SAME column ?
>
>
>oExcel.activesheet.Range("D"+TRIM(PADR(nrow,11))).ColumnWidth = 15
>oExcel.activesheet.Range("D"+TRIM(PADR(nrow,11))).value = rpt012->itmcode
>
>oExcel.activesheet.Range("D"+TRIM(PADR(nrow,11))).ColumnWidth = 40
>oExcel.activesheet.Range("D"+TRIM(PADR(nrow,11))).value = rpt012->desc
>
>
>I found it the result have same column width 40.
>
>Please advise.
>Thanks.
>Derek Yim
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)