Is there a way or formula to display the name of the range a cell is in?

[mark hansen]

I have a worksheet with 225 cells that have a range name. Each range is a single cell. Is there a way to have the Range name display in the cell?

I've done some searches and discovered I can get a list of all of my ranges and the cell reference and I can paste them in worksheet as a reference.
I know I can use name manager to display a list of range name and where it is....
I know I can zoom out to 40% to get range names, doesn't work when when the range name refers to only one cell.

What I (think) I want to do is put a formula in a cell that will display the range name the cell is contained in. In my case they are one cell ranges that VBA refers to.

Am I barking up a dead tree?

Thanks
Mark

 

[JenniferMurphy]

Now, can anyone suggest a way for the UDF code to determine if the cell(s) at pAddr are part of a larger named range?