ActiveX

To remove a span

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 don't know the anchor cell coordinates for the span you want to remove, use the GetCellSpan method to return the anchor cell.
3. Use the RemoveCellSpan method to remove the span, setting the lCol and lRow parameters to the coordinates of the anchor cell for the span.