ActiveX

To insert 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 are inserting columns,
   1. If you do not want to delete the rightmost column or columns, increase the setting of the MaxCols property by the number of columns you are adding to the sheet.
   2. Call the InsertCols method and set the parameters as follows,
      1. Set the Col parameter to the column before which the new column or new range of columns will be inserted.
      2. Set the NumCols parameter to the number of columns to insert.
3. If you are inserting rows,
   1. If you do not want to delete the bottom row or rows, increase the setting of the MaxRows property by the number of rows you are adding to the sheet.
   2. Call the InsertRows method and set the parameters as follows,
      1. Set the Row parameter to the row before which the new row or new range of rows will be inserted.
      2. Set the NumRows parameter to the number of rows to insert.