'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