Creates a named Range of cells from a specified formula. A
Range is a collection of Area s; an
Area area is a rectangular collection of cells.
rangeFormulaFormula 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.
rangeNameThe name to assign to the range.
Rangeobject representing the range of cells created.
RemarksNote that if a range named
rangeNamealready exists in the workbook, it will be overwritten with the new named range created by this method.