Share via


Range Object

Multiple objects
Range
Multiple objects

Represents a cell, a range of cells, a row, or a column.

Using the Range Object

The following properties and methods return a Range object.

Object Properties/Methods
AutoFilter Range
ListObject DataBodyRange
HeaderRowRange
InsertRowRange
Range
ListRow Range
Name RefersToRange
Pane VisibleRange
Range Cells
Columns
CurrentArray
CurrentRegion
End
EntireColumn
EntireRow
Find
FindNext
FindPrevious
Item
MergeArea
Next
Offset
Previous
Range
Rows
Spreadsheet ActiveCell
Cells
Columns
Range
RectIntersect
RectUnion
Rows
Selection
Window ActiveCell
RangeFromPoint
RangeSelection
Selection
VisibleRange
Worksheet Cells
Columns
Range
Rows
UsedRange

Properties | Address Property | Application Property | Borders Property | Cells Property | Column Property | Columns Property | ColumnWidth Property | Count Property | CurrentArray Property | CurrentRegion Property | End Property | EntireColumn Property | EntireRow Property | Font Property | Formula Property | FormulaArray Property | FormulaLocal Property | HasArray Property | HasFormula Property | Height Property | Hidden Property | HorizontalAlignment Property | HTMLData Property | Hyperlink Property | Interior Property | Item Property | Left Property | ListObject Property | Locked Property | MergeArea Property | MergeCells Property | Name Property | Next Property | NumberFormat Property | Offset Property | Parent Property | PrefixCharacter Property | Previous Property | Range Property | ReadingOrder Property | Row Property | RowHeight Property | Rows Property | Text Property | Top Property | UseStandardHeight Property | UseStandardWidth Property | Value Property | Value2 Property | VerticalAlignment Property | Width Property | Worksheet Property

Methods | Activate Method | AutoFilter Method | AutoFit Method | BorderAround Method | Calculate Method | Clear Method | ClearContents Method | ClearFormats Method | Copy Method | CopyFromRecordset Method | Cut Method | Delete Method | FillDown Method | FillRight Method | Find Method | FindNext Method | FindPrevious Method | Insert Method | LoadText Method | Merge Method | ParseText Method | Paste Method | Select Method | Show Method | Sort Method | UnMerge Method | Validate Method

Events | Change Event

Parent Objects | AutoFilter Object | Border Object | Borders Collection | Hyperlink Object | ListObject Object | ListRow Object | Name Object | Pane Object | Range Object | Spreadsheet Object | Window Object | Worksheet Object

Child Objects | Borders Object | Font Object | Hyperlink Object | Interior Object | ListObject Object | Name Object | Range Object | Worksheet Object