A Range object represents a range in a workbook.

[DefaultMember("Item")]
 public sealed class Range
<DefaultMember("Item")> _
	Public NotInheritable Class Range

A range is a collection of areas. An area is a rectangular collection of cells. The areas in a range may be non-adjacent, and a range can include areas in different worksheets.

To create a Range (without a name), call one of the following methods:

If a range is named, it will be accessible when the workbook is opened in Microsoft Excel. To create a named range, call one of the following methods:


          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          wb.Worksheets.CreateWorksheet("Sheet2");
          Range rng = wb.CreateRange("=Sheet1!A1:A3, Sheet2!A2:C5");
        

          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Create()
          wb.Worksheets.CreateWorksheet("Sheet2")
          Dim rng As Range = wb.CreateRange("=Sheet1!A1:A3, Sheet2!A2:C5")
        

Name

Description

AreaCount

Areas

BorderAround

FirstCellStyle

Name

Description

Item(Int32)

Name

Description

ApplyStyle(Style)

ClearContent()

JoinRange(Range)

RemoveConditionalFormat()

SetConditionalFormat(ConditionalFormat)

SetDataValidation(DataValidation)

SetStyle(Style)

ToString()