Lotus 123 column width 1

[SMessier]

Hi,

I would like to use a Lotus script command to enlarge a column to its largest value. Manually, you do it by double-cliking on the right side of the column title. How can I do it via Lotus script?

Thanks

Stephane Messier

 

[Charmaine]

You can do this in 2 ways:
1. Use range.ColumnWidth = value. (You will need to know the width which you would like the column for this one.)
Eg. To change column C of sheet A to a width of 32
[A:C1].ColumnWidth = 32

2. Use range.FitWidest. Adjusts the column widths to fit the widest cell entries included in a range or collection of ranges.
Eg. [A:C1].FitWidest