By default, MSHFlexGrid has one fixed column and one fixed row.
Syntax
object.FixedCols [= value]
object.FixedRows [= value]
Syntax for the FixedCols and FixedRows properties has these parts:
| Part | Description |
| object | An object expression that evaluates to an object in the Applies To list. |
| value | A Long value that specifies the total number of fixed columns or fixed rows. |
Remarks
Fixed columns and rows are constant when you scroll other columns or rows in the MSHFlexGrid. You can specify zero or multiple fixed columns rows. In addition, you can select the colors, font, gridline, and text style of the fixed columns and rows.
If the SelectionMode property is a numerical value, when you select a fixed row or fixed column at run time, all cells within that row or column are selected.
If the AllowUserResizing property is a numerical value, you can resize the fixed rows or fixed columns at run time.
Fixed columns and fixed rows are used in spreadsheet applications to display row numbers and column names or letters.