ActiveX

To display a specified number of columns and rows

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. Specify the number of columns to display with the VisibleCols property.
3. Specify the number of rows to display with the VisibleRows property.
4. If you want to prevent partial display of columns and rows, set the AutoSize property to True.