The following tables list the members exposed by SpreadsheetSelection.
Name | Description | |
---|---|---|
ActiveCell | Returns the cell that represents the active cell. | |
ActiveCellRangeIndex | Returns the index of the selection group that contains the active cell. | |
CellRanges | Returns a read-only collection of the ranges of cells that are selected. | |
CellRangesAddress | Returns or sets a string containing the cell ranges in A1 cell reference mode. |
Name | Description | |
---|---|---|
AddActiveCellRange | Overloaded. Adds a new cell range for the specified cell and makes it the active cell. | |
AddCellRange | Overloaded. Adds a new range to the end of the CellRanges | |
ClearCellRanges | Resets the CellRanges to a single range containing only the ActiveCell | |
ReplaceActiveCellRange | Overloaded. Replaces the range containing the ActiveCell with the specified range and using the specified cell as the new ActiveCell. | |
Reset | Resets all the properties to their default values | |
ResetCellRangesAddress | Resets the CellRangesAddress property to its default value. | |
ResetSelection | Overloaded. Clears the current selection and uses the specified cell as the ActiveCell and specified range as the new selection. | |
SetActiveCell | Overloaded. Changes the ActiveCell and ActiveCellRangeIndex to the specified values. | |
UnselectRange | Deselect the cells in the specified range. |
Name | Description | |
---|---|---|
ShouldSerializeCellRangesAddress | Indicates if the CellRangesAddress property needs to be serialized. |