Creates an XLNamedRange object and appends it to the collection. This overload allows you to create a 3-D reference to the same range of cells on multiple worksheets.

Namespace:  C1.Silverlight.Excel
Assembly:  C1.Silverlight.Excel.5 (in C1.Silverlight.Excel.5.dll)

Syntax

C#
public XLNamedRange Add(
	string name,
	int firstSheetIndex,
	int lastSheetIndex,
	int rowIndex,
	int colIndex
)
Visual Basic
Public Function Add ( _
	name As String, _
	firstSheetIndex As Integer, _
	lastSheetIndex As Integer, _
	rowIndex As Integer, _
	colIndex As Integer _
) As XLNamedRange

Parameters

name
Type: System..::..String
The name of XLNamedRange object.
firstSheetIndex
Type: System..::..Int32
The index of the first XLSheet to include.
lastSheetIndex
Type: System..::..Int32
The index of the last XLSheet to include.
rowIndex
Type: System..::..Int32
The index of the top row in the cell range.
colIndex
Type: System..::..Int32
The index of the left column in the cell range.

Return Value

A reference to the object if it was successfully added to the collection, or null if the object could not be added (usually because it overlaps another cell range already in the collection).

See Also