IRange Interface

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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()

Applies to