WorksheetCollection.GetRangeByName

GetRangeByName(string)

Gets Range object by pre-defined name.

public Range GetRangeByName(string rangeName)
ParameterTypeDescription
rangeNameStringName of range.

Return Value

Range object.

Returns null if the named range does not exist.

See Also


GetRangeByName(string, int, bool)

Gets Range by pre-defined name or table’s name

public Range GetRangeByName(string rangeName, int currentSheetIndex, bool includeTable)
ParameterTypeDescription
rangeNameStringName of range or table’s name.
currentSheetIndexInt32The sheet index. -1 represents global .
includeTableBooleanIndicates whether checking all tables.

See Also