get name of a range vba code example
Example: 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
'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