ActiveX

To delete 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. If you want to delete columns,
   1. Call the DeleteCols method.
   2. Set the Col parameter to the column number of the column to delete, or first column number of a range of columns to be deleted.
   3. Set the NumCols parameter to the number of columns to delete.
3. If you want to delete rows,
   1. Call the DeleteRows method.
   2. Set the Row parameter to the row number of the row to delete, or first row number of a range of rows to be deleted.
   3. Set the NumRows parameter to the number of rows to delete.