Returns the specified named Range. If the named range does not exist, the method returns null.
public Range GetNamedRange(System.String name)
Public Function GetNamedRange(ByVal name As String) As Range
The name of the range.
A named Range object, or null if the range does not exist.
Range
Range rng = wb.GetNamedRange("Range1");
Dim rng As Range = wb.GetNamedRange("Range1")