.
| Description |
|---|
| Excerpt |
|---|
Creates a range from a specified formula. A range is a collection of areas; an area is a rectangular collection of cells. This method can be used to create a non-rectangular range containing multiple rectangular areas. |
| Signature | C# | C# |
|---|---|---|
| Wiki Markup | ||
{description}
{excerpt}Creates a range from a specified formula. A range is a collection of areas; an area is a rectangular collection of cells. This method can be used to create a non-rectangular range containing multiple rectangular areas.{excerpt}
{signature:C#}
public Range CreateRange(System.String rangeFormula)
| ||
| Signature | ||
{signature}{signature:vb.net | vb.net | }
Public Function CreateRange(ByVal rangeFormula As String) As Range
|
| Parameters |
|---|
| Param | ||
|---|---|---|
| rangeFormula | rangeFormula | Formula representing the range, for example {signature} {parameters} {param:rangeFormula}Formula representing the range, for example "=A1:G10". The formula must be two\-dimensional, and can include cell references, and operators joining those references \(range ':', intersection ' ', and union ','\). Functions that return ranges cannot be used. |
| Returns |
|---|
A Range object. |
| Example | |||
|---|---|---|---|
| Code Block | | csharp | csharp |
| title | C# | ||
| Code Block | vb.net | title |