IRange Interface

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Reserved for internal use.

public interface class IRange : System::Collections::IEnumerable

[System.Runtime.InteropServices.Guid("00020846-0001-0000-C000-000000000046")]
public interface IRange : System.Collections.IEnumerable

Public Interface IRange
Implements IEnumerable

Attributes

GuidAttribute

Implements

IEnumerable

Properties

_Default[Object, Object]

AddIndent

Address[Object, Object, XlReferenceStyle, Object, Object]

AddressLocal[Object, Object, XlReferenceStyle, Object, Object]

AllowEdit

Application

Areas

Borders

Cells

Characters[Object, Object]

Column

Columns

ColumnWidth

Comment

Count

CountLarge

Creator

CurrentArray

CurrentRegion

Dependents

DirectDependents

DirectPrecedents

DisplayFormat

End[XlDirection]

EntireColumn

EntireRow

Errors

Font

FormatConditions

Formula

FormulaArray

FormulaHidden

FormulaLabel

FormulaLocal

FormulaR1C1

FormulaR1C1Local

HasArray

HasFormula

Height

Hidden

HorizontalAlignment

Hyperlinks

ID

IndentLevel

Interior

Item[Object, Object]

Left

ListHeaderRows

ListObject

LocationInTable

Locked

MDX

MergeArea

MergeCells

Name

Next

NumberFormat

NumberFormatLocal

Offset[Object, Object]

Orientation

OutlineLevel

PageBreak

Parent

Phonetic

Phonetics

PivotCell

PivotField

PivotItem

PivotTable

Precedents

PrefixCharacter

Previous

QueryTable

Range[Object, Object]

ReadingOrder

Resize[Object, Object]

Row

RowHeight

Rows

ServerActions

ShowDetail

ShrinkToFit

SmartTags

SoundNote

SparklineGroups

Style

Summary

Text

Top

UseStandardHeight

UseStandardWidth

Validation

Value[Object]

Value2

VerticalAlignment

Width

Worksheet

WrapText

XPath

Methods

_PasteSpecial(XlPasteType, XlPasteSpecialOperation, Object, Object)

_PrintOut(Object, Object, Object, Object, Object, Object, Object)

Activate()

AddComment(Object)

AdvancedFilter(XlFilterAction, Object, Object, Object)

AllocateChanges()

ApplyNames(Object, Object, Object, Object, Object, XlApplyNamesOrder, Object)

ApplyOutlineStyles()

AutoComplete(String)

AutoFill(Range, XlAutoFillType)

AutoFilter(Object, Object, XlAutoFilterOperator, Object, Object)

AutoFit()

AutoFormat(XlRangeAutoFormat, Object, Object, Object, Object, Object, Object)

AutoOutline()

BorderAround(Object, XlBorderWeight, XlColorIndex, Object)

BorderAround2(Object, XlBorderWeight, XlColorIndex, Object, Object)

Calculate()

CalculateRowMajorOrder()

CheckSpelling(Object, Object, Object, Object)

Clear()

ClearComments()

ClearContents()

ClearFormats()

ClearHyperlinks()

ClearNotes()

ClearOutline()

ColumnDifferences(Object)

Consolidate(Object, Object, Object, Object, Object)

Copy(Object)

CopyFromRecordset(Object, Object, Object)

CopyPicture(XlPictureAppearance, XlCopyPictureFormat)

CreateNames(Object, Object, Object, Object)

CreatePublisher(Object, XlPictureAppearance, Object, Object, Object, Object)

Cut(Object)

DataSeries(Object, XlDataSeriesType, XlDataSeriesDate, Object, Object, Object)

Delete(Object)

DialogBox()

Dirty()

DiscardChanges()

EditionOptions(XlEditionType, XlEditionOptionsOption, Object, Object, XlPictureAppearance, XlPictureAppearance, Object)

ExportAsFixedFormat(XlFixedFormatType, Object, Object, Object, Object, Object, Object, Object, Object)

FillDown()

FillLeft()

FillRight()

FillUp()

Find(Object, Object, Object, Object, Object, XlSearchDirection, Object, Object, Object)

FindNext(Object)

FindPrevious(Object)

FlashFill()

FunctionWizard()

GetEnumerator()

GoalSeek(Object, Range)

Group(Object, Object, Object, Object)

Insert(Object, Object)

InsertIndent(Int32)

Justify()

ListNames()

Merge(Object)

NavigateArrow(Object, Object, Object)

NoteText(Object, Object, Object)

Parse(Object, Object)

PasteSpecial(XlPasteType, XlPasteSpecialOperation, Object, Object)

PrintOut(Object, Object, Object, Object, Object, Object, Object, Object)

PrintOutEx(Object, Object, Object, Object, Object, Object, Object, Object)

PrintPreview(Object)

RemoveDuplicates(Object, XlYesNoGuess)

RemoveSubtotal()

Replace(Object, Object, Object, Object, Object, Object, Object, Object)

RowDifferences(Object)

Run(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Select()

SetPhonetic()

Show()

ShowDependents(Object)

ShowErrors()

ShowPrecedents(Object)

Sort(Object, XlSortOrder, Object, Object, XlSortOrder, Object, XlSortOrder, XlYesNoGuess, Object, Object, XlSortOrientation, XlSortMethod, XlSortDataOption, XlSortDataOption, XlSortDataOption)

SortSpecial(XlSortMethod, Object, XlSortOrder, Object, Object, XlSortOrder, Object, XlSortOrder, XlYesNoGuess, Object, Object, XlSortOrientation, XlSortDataOption, XlSortDataOption, XlSortDataOption)

Speak(Object, Object)

SpecialCells(XlCellType, Object)

SubscribeTo(String, XlSubscribeToFormat)

Subtotal(Int32, XlConsolidationFunction, Object, Object, Object, XlSummaryRow)

Table(Object, Object)

TextToColumns(Object, XlTextParsingType, XlTextQualifier, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Ungroup()

UnMerge()