ROW.HEIGHT macro

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.

If reference is omitted, the reference is assumed to be the current selection.
If reference is specified, it must be either an external reference to the active worksheet, such as !$2:$4 or !Database, or an R1C1-style reference in the form of text or a name, such as "R1:R3", "R[-4]:R[-2]", or Database.
If reference is a relative R1C1-style reference in the form of text, it is assumed to be relative to the active cell.

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

If standard_height is TRUE, Microsoft Excel sets the row height to a standard height that may vary from row to row depending on the fonts used in each row, ignoring height_num.
If standard_height is FALSE or omitted, Microsoft Excel sets the row height according to height_num.

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

If any of the argument settings conflict, such as when standard_height is TRUE and type_num is 3, Microsoft Excel uses the type_num argument and ignores any arguments that conflict with type_num.
If you are recording a macro while using a mouse, and you change row heights by dragging the row border, Microsoft Excel records the reference of the rows using R1C1-style references in the form of text. If Uses Relative References is selected, Microsoft Excel uses R1C1-style relative references. If Uses Relative References is not selected, Microsoft Excel uses R1C1-style absolute references.

Related Function

COLUMN.WIDTH Sets the widths of the specified columns

Return to index