vba get named range value code example
Example 1: get name of a range vba
'For a Range, Name isn t a string it s a Name object
'that you then take the Name property of to get the string
MsgBox sampleRange.Name.Name
Example 2: vba set named range
' Scope.Names.Add Name:=RangeName, RefersTo:=NamedRange
'Example:
ThisWorkbook.Names.Add Name:="myRangeName", RefersTo:=Range("A1")