Creates a Range of cells from a specified formula. A Range is a collection of Area s; an Area area is a rectangular collection of cells.

 public Range CreateRange(System.String rangeFormula)

Public Function CreateRange(ByVal rangeFormula As String) As Range

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.

A Range object representing the range of cells created.

Range rng = wb.CreateRange("=Sheet1!A1:G10");
Dim rng As Range = wb.CreateRange("=Sheet1!A1:G10")