Right-click Context Menu of the column(s): Column Width
Set width of worksheet columns
wcolwidth irng:=[Book1]Sheet1!Col(3) width:=20;
Please refer to the page for additional option switches when accessing the x-function from script
Input
Range
Specify the column(s).
double
Specify the column width. The value is the ratio with respect to the default font width, which means a value 7 for wcolwidth means that you can display 7 characters of system default font in a column of default width.
This function is used to update the width of the columns in the worksheet.
wrowheight