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:vb.net} Public Function CreateRange(ByVal rangeFormula As String) As Range {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.{param} {returns}A [Range|Range] object.{returns} {example}{code:csharp|title=C#} Range rng = ws.CreateRange("=$B$12:$H$21 $F$18:$K$29"); {code} {code:vb.net|title=vb.net} Dim rng As Range = ws.CreateRange("=$B$12:$H$21 $F$18:$K$29") {code} {example} |
Page History
Overview
Content Tools