This class represents a cell, a row, a column, or a collection of cells in the a sheet.
Properties
Application through getApplication
BackColor through getBackgroundColor and setBackgroundColor
Count through getCount
Column through getColumn
ColumnWidth through getColumnWidth and setColumnWidth
EndColumn through getEndColumn
EndRow through getEndRow
EntireColumn through getEntireColumn
EntireRow through getEntireRow
Font through getFont
Formula through getFormula and setFormula
FormulaHidden through isFormulaHidden and setFormulaHidden
HasFormula through hasFormula
Height through getHeight
Hidden through isHidden and setHidden
MergeCell through isMergeCell and setMergeCell
Name through getName
Protected through isProtected and setProtected
PrintHidden through isPrintHidden and setPrintHidden
Row through getRow
RowHeight through getRowHeight and setRowHeight
Sheet through getSheet
StartColumn through getStartColumn
StartRow through getStartRow
Text through getText and setText
Value through getValue and setValue
Width through getWidth
WrapText through isWrapText and setWrapText
Methods
Usage
Range provides access to cells, columns, and rows, and methods to provide sort, group, and subtotal operations.
To change the style of the range use the Borders method and the BackColor and Font properties.
To set formula for cells, use the Formula property.