Microsoft Office Tutorials and References
In Depth Information
Chapter 19. The Range Object
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.
Table 9-1. Members of the Range Object 1
_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
ShowPrecedents
ClearContents
ID<v9>
ShrinkToFit
ClearFormats
IndentLevel
SmartTags<v10>
ClearNotes
Insert
Sort
ClearOutline
InsertIndent
SortSpecial
Column
Interior
SoundNote
 
 
Search JabSto ::




Custom Search