Page History

{description}
{excerpt}A [Range|Range] object represents a range in a workbook.{excerpt}
{signature:C#}
[DefaultMember("Item")]
 public sealed class Range
{signature}{signature:vb.net}
<DefaultMember("Item")> _
	Public NotInheritable Class Range
{signature}
{remarks}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:
* [Workbook.CreateRange(rangeFormula)|Workbook.CreateRange(String)]
* [Worksheet.CreateRange(rangeFormula)|Worksheet.CreateRange(String)]

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:
* [Workbook.CreateNamedRange(rangeFormula, rangeName)|Workbook.CreateNamedRange(String, String)]
* [Worksheet.CreateNamedRange(firstRow, firstColumn, numRows, numColumns, rangeName)|Worksheet.CreateNamedRange(Int32, Int32, Int32, Int32, String)]
* [Worksheet.CreateNamedRange(rangeFormula, rangeName)|Worksheet.CreateNamedRange(String, String)]

{remarks}
{example}{code:csharp|title=C#}

          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          wb.Worksheets.CreateWorksheet("Sheet2");
          Range rng = wb.CreateRange("=Sheet1!A1:A3, Sheet2!A2:C5");
        {code}
{code:vbnet|title=vb.net}

          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")
        {code}

{example}
{properties}
||Name||Description||
|[AreaCount|Range.AreaCount]|{excerpt-include:Range.AreaCount|nopanel=true}|
|[Areas|Range.Areas]|{excerpt-include:Range.Areas|nopanel=true}|
|[BorderAround|Range.BorderAround]|{excerpt-include:Range.BorderAround|nopanel=true}|
|[FirstCellStyle|Range.FirstCellStyle]|{excerpt-include:Range.FirstCellStyle|nopanel=true}|
{indexers}
||Name||Description||
|[Item(Int32)|Range.Item(Int32)]|{excerpt-include:Range.Item(Int32)|nopanel=true}|
{methods}
||Name||Description||
|[ApplyStyle(Style)|Range.ApplyStyle(Style)]|{excerpt-include:Range.ApplyStyle(Style)|nopanel=true}|
|[ClearContent()|Range.ClearContent()]|{excerpt-include:Range.ClearContent()|nopanel=true}|
|[JoinRange(Range)|Range.JoinRange(Range)]|{excerpt-include:Range.JoinRange(Range)|nopanel=true}|
|[RemoveConditionalFormat()|Range.RemoveConditionalFormat()]|{excerpt-include:Range.RemoveConditionalFormat()|nopanel=true}|
|[SetConditionalFormat(ConditionalFormat)|Range.SetConditionalFormat(ConditionalFormat)]|{excerpt-include:Range.SetConditionalFormat(ConditionalFormat)|nopanel=true}|
|[SetDataValidation(DataValidation)|Range.SetDataValidation(DataValidation)]|{excerpt-include:Range.SetDataValidation(DataValidation)|nopanel=true}|
|[SetStyle(Style)|Range.SetStyle(Style)]|{excerpt-include:Range.SetStyle(Style)|nopanel=true}|
|[ToString()|Range.ToString()]|{excerpt-include:Range.ToString()|nopanel=true}|