Row height in Excel

[archana.gupta]

Hello Friends,

I want to control the height of the row in Excel sheet thru progress 4GL. Please advice.

Thanks,
Archana

 

[archana.gupta]

chWorksheet:Rows("6:6"):RowHeight = 5

 

[enoon]

Hello Friends,

I want to control the height of the row in Excel sheet thru progress 4GL. Please advice.

Thanks,
Archana

The simplest way to do something in excell that you don't know from progress is: go to tools -> macro -> record, press alt+F11 to see the VBA code, and translate that to progress something like hShet:Range("1:1"):RowHeight = 200