Hi. Below is a post from Tom Ogilvy that was posted back in 2003. The post
involved identifying which named range a given cell belonged to. So I took
the below snippets, created a named range called "test" in cells a1:c5. But
when I select b3, and run the below in the immediate window, I get b3 back
for the .address. For .name, I get an error. Am I doing something wrong?

? Range("A1").CurrentRegion.address
$A$1:$C$5
? Range("A1").CurrentRegion.name
=Sheet1!$A$1:$C$5
? Range("A1").CurrentRegion.name.name
MyRange