ActiveX
To set the maximum number of columns and rows
- If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
- Specify the maximum number of columns by setting the MaxCols property.
- Specify the maximum number of rows by setting the MaxRows property.