Partager via

IRange Members

  • Article

Include Protected Members
Include Inherited Members

Reserved for internal use.

The IRange type exposes the following members.

Properties

  Name Description
Public property _Default
Public property AddIndent
Public property Address
Public property AddressLocal
Public property AllowEdit
Public property Application
Public property Areas
Public property Borders
Public property Cells
Public property Characters
Public property Column
Public property Columns
Public property ColumnWidth
Public property Comment
Public property Count
Public property CountLarge
Public property Creator
Public property CurrentArray
Public property CurrentRegion
Public property Dependents
Public property DirectDependents
Public property DirectPrecedents
Public property DisplayFormat
Public property End
Public property EntireColumn
Public property EntireRow
Public property Errors
Public property Font
Public property FormatConditions
Public property Formula
Public property FormulaArray
Public property FormulaHidden
Public property FormulaLabel
Public property FormulaLocal
Public property FormulaR1C1
Public property FormulaR1C1Local
Public property HasArray
Public property HasFormula
Public property Height
Public property Hidden
Public property HorizontalAlignment
Public property Hyperlinks
Public property ID
Public property IndentLevel
Public property Interior
Public property Item
Public property Left
Public property ListHeaderRows
Public property ListObject
Public property LocationInTable
Public property Locked
Public property MDX
Public property MergeArea
Public property MergeCells
Public property Name
Public property Next
Public property NumberFormat
Public property NumberFormatLocal
Public property Offset
Public property Orientation
Public property OutlineLevel
Public property PageBreak
Public property Parent
Public property Phonetic
Public property Phonetics
Public property PivotCell
Public property PivotField
Public property PivotItem
Public property PivotTable
Public property Precedents
Public property PrefixCharacter
Public property Previous
Public property QueryTable
Public property Range
Public property ReadingOrder
Public property Resize
Public property Row
Public property RowHeight
Public property Rows
Public property ServerActions
Public property ShowDetail
Public property ShrinkToFit
Public property SmartTags
Public property SoundNote
Public property SparklineGroups
Public property Style
Public property Summary
Public property Text
Public property Top
Public property UseStandardHeight
Public property UseStandardWidth
Public property Validation
Public property Value
Public property Value2
Public property VerticalAlignment
Public property Width
Public property Worksheet
Public property WrapText
Public property XPath

Top

Methods

  Name Description
Public method _PasteSpecial
Public method _PrintOut
Public method Activate
Public method AddComment
Public method AdvancedFilter
Public method AllocateChanges
Public method ApplyNames
Public method ApplyOutlineStyles
Public method AutoComplete
Public method AutoFill
Public method AutoFilter
Public method AutoFit
Public method AutoFormat
Public method AutoOutline
Public method BorderAround
Public method BorderAround2
Public method Calculate
Public method CalculateRowMajorOrder
Public method CheckSpelling
Public method Clear
Public method ClearComments
Public method ClearContents
Public method ClearFormats
Public method ClearHyperlinks
Public method ClearNotes
Public method ClearOutline
Public method ColumnDifferences
Public method Consolidate
Public method Copy
Public method CopyFromRecordset
Public method CopyPicture
Public method CreateNames
Public method CreatePublisher
Public method Cut
Public method DataSeries
Public method Delete
Public method DialogBox
Public method Dirty
Public method DiscardChanges
Public method EditionOptions
Public method ExportAsFixedFormat
Public method FillDown
Public method FillLeft
Public method FillRight
Public method FillUp
Public method Find
Public method FindNext
Public method FindPrevious
Public method FunctionWizard
Public method GetEnumerator() (Inherited from IEnumerable.)
Public method GetEnumerator()
Public method GoalSeek
Public method Group
Public method Insert
Public method InsertIndent
Public method Justify
Public method ListNames
Public method Merge
Public method NavigateArrow
Public method NoteText
Public method Parse
Public method PasteSpecial
Public method PrintOut
Public method PrintOutEx
Public method PrintPreview
Public method RemoveDuplicates
Public method RemoveSubtotal
Public method Replace
Public method RowDifferences
Public method Run
Public method Select
Public method SetPhonetic
Public method Show
Public method ShowDependents
Public method ShowErrors
Public method ShowPrecedents
Public method Sort
Public method SortSpecial
Public method Speak
Public method SpecialCells
Public method SubscribeTo
Public method Subtotal
Public method Table
Public method TextToColumns
Public method Ungroup
Public method UnMerge

Top

See Also

Reference

IRange Interface

Microsoft.Office.Interop.Excel Namespace