ActiveX
To set the height of a row
- If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
-
At run time, specify the row height with the RowHeight property.
Specify the row in the lRow parameter of this property. lRow values are zero-based. Use the following values to designate the row height for the following parts of the control:
| To set the row height for . . . | Use the lRow value . . . |
|---|---|
| Column header | 0 |
| All rows | –1 |
| Row specified by the Row property | –2 |