...
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 | ||||
---|---|---|---|---|
| ||||
public Range CreateRange(System.String rangeFormula)
{signature}{signature: |
Signature | ||||||
---|---|---|---|---|---|---|
| }
| |||||
Public Function CreateRange(ByVal rangeFormula As String) As Range
{signature}
{parameters}
{param:rangeFormula}Formula representing the range, for example |
Parameters |
---|
Param | ||||
---|---|---|---|---|
| ||||
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. {param} {returns}A [Range|Range] object.{returns} {example}{code:csharp|title=C#} |
Returns |
---|
A Range object. |
Example | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|