Chapter 19. The Range Object
The Range object is one of the workhorse objects in the Excel object model. Simply put, to work with a portion of an Excel worksheet, we generally need to first identify that portion as a Range object.
As Microsoft puts it, a Range object “Represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range.”
Table 19-1 shows the 158 members of the Range object.
|
_Default |
End |
Phonetic |
|
_NewEnum |
EntireColumn |
Phonetics<v9> |
|
_PasteSpecial<v10> |
EntireRow |
PivotCell<v10> |
|
_PrintOut<v9> |
Errors<v10> |
PivotField |
|
Activate |
FillDown |
PivotItem |
|
AddComment |
FillLeft |
PivotTable |
|
AddIndent |
FillRight |
Precedents |
|
Address |
FillUp |
PrefixCharacter |
|
AddressLocal |
Find |
Previous |
|
AdvancedFilter |
FindNext |
PrintOut |
|
AllowEdit<v10> |
FindPrevious |
PrintPreview |
|
Application |
Font |
QueryTable |
|
ApplyNames |
FormatConditions |
Range |
|
ApplyOutlineStyles |
Formula |
ReadingOrder |
|
Areas |
FormulaArray |
RemoveSubtotal |
|
AutoComplete |
FormulaHidden |
Replace |
|
AutoFill |
FormulaLabel |
Resize |
|
AutoFilter |
FormulaLocal |
Row |
|
AutoFit |
FormulaR1C1 |
RowDifferences |
|
AutoFormat |
FormulaR1C1Local |
RowHeight |
|
AutoOutline |
FunctionWizard |
Rows |
|
BorderAround |
GoalSeek |
Run |
|
Borders |
Group |
Select |
|
Calculate |
HasArray |
SetPhonetic<v9> |
|
Cells |
HasFormula |
Show |
|
Characters |
Height |
ShowDependents |
|
CheckSpelling |
Hidden |
ShowDetail |
|
Clear |
HorizontalAlignment |
ShowErrors |
|
ClearComments |
Hyperlinks |
Get Writing Excel Macros with VBA, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
