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.

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