Wiki Markup |
---|
{description} {excerpt}Creates a [Range|Range] of cells from a specified formula. A {{Range}} is a collection of [Area|Area] s; an {{Area}} area is a rectangular collection of cells.{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 "=Sheet1\!A1:G10". The formula must be three\-dimensional \(specify a sheet\), and can include only sheet and cell references, and operators joining those references \(range ':', intersection ' ', and union ','\). Functions that return ranges cannot be used.{param} {returns}A {{Range}} object representing the range of cells created.{returns} {example}{code:csharp|title=C#} Range rng = wb.CreateRange("=Sheet1!A1:G10");{code} {code:vb.net|title=vb.net} Dim rng As Range = wb.CreateRange("=Sheet1!A1:G10"){code} {example} |
Page History
Overview
Content Tools