ActiveX
To remove a span
- If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
- If you don't know the anchor cell coordinates for the span you want to remove, use the GetCellSpan method to return the anchor cell.
- Use the RemoveCellSpan method to remove the span, setting the lCol and lRow parameters to the coordinates of the anchor cell for the span.