ActiveX
To span cells
- If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
-
If you want to verify whether a cell is already in a span, use the GetCellSpan method to return whether a cell is in a span, and if it is in a span, the anchor cell for the span.
The control will not allow a cell in a span to be included in another span. However, you might want to check a cell, and display a message for users if they try to add a cell in a span to another span.
- Use the AddCellSpan method to create the span, setting the parameters as follows,