Version

SpreadsheetSelection Class Members

The following tables list the members exposed by SpreadsheetSelection.

Public Properties
 NameDescription
Public PropertyActiveCellReturns the cell that represents the active cell.  
Public PropertyActiveCellRangeIndexReturns the index of the selection group that contains the active cell.  
Public PropertyCellRangesReturns a read-only collection of the ranges of cells that are selected.  
Public PropertyCellRangesAddressReturns or sets a string containing the cell ranges in A1 cell reference mode.  
Public Methods
 NameDescription
Public MethodAddActiveCellRangeOverloaded. Adds a new cell range for the specified cell and makes it the active cell.  
Public MethodAddCellRangeOverloaded. Adds a new range to the end of the CellRanges  
Public MethodClearCellRangesResets the CellRanges to a single range containing only the ActiveCell  
Public MethodReplaceActiveCellRangeOverloaded. Replaces the range containing the ActiveCell with the specified range and using the specified cell as the new ActiveCell.  
Public MethodResetResets all the properties to their default values  
Public MethodResetCellRangesAddressResets the CellRangesAddress property to its default value.  
Public MethodResetSelectionOverloaded. Clears the current selection and uses the specified cell as the ActiveCell and specified range as the new selection.  
Public MethodSetActiveCellOverloaded. Changes the ActiveCell and ActiveCellRangeIndex to the specified values.  
Public MethodUnselectRangeDeselect the cells in the specified range.  
Protected Methods
 NameDescription
Protected MethodShouldSerializeCellRangesAddressIndicates if the CellRangesAddress property needs to be serialized.  
See Also