Dim sampleRange as Range
Set sampleRange = Worksheet.Range(Cells(1,1),Cells(1,4)
sampleRange.Name = "Range1"
MsgBox sampleRange.Nname
This will show the actual address of the range, not the name. Why?
How do I get a named range to return its name?