ROW.HEIGHT

Macro Sheets Only

Equivalent to choosing the Height command on the Row submenu of the Format menu. Changes the height of the rows in a reference.

Syntax

ROW.HEIGHT(height_num, reference, standard_height, type_num)
ROW.HEIGHT?(height_num, reference, standard_height, type_num)

Height_num specifies how high you want the rows to be in points. If standard_height is TRUE, height_num is ignored.

Reference specifies the rows for which you want to change the height.

Standard_height is a logical value that sets the row height as determined by the font in each row.

Type_num is a number from 1 to 3 corresponding to selecting the Hide, Unhide, or AutoFit commands from the Row submenu.

Type_num Action taken

1 Hides the row selection by setting the row height to 0

2 Unhides the row selection by setting the row height to the value set before the selection was hidden

3 Sets the row selection to an AutoFit height, which varies from row to row depending on how large the font is in any cell in each row or on how many lines of text are wrapped

Remarks

Related Function

COLUMN.WIDTH Sets the widths of the specified columns

List of Command-Equivalent Functions