ActiveX

To set the maximum 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 maximum number of columns by setting the MaxCols property.
3. Specify the maximum number of rows by setting the MaxRows property.