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

mark hansen

Well-known Member
Joined
Mar 6, 2006
Messages
534
Office Version
  1. 2016
Platform
  1. Windows
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
 
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? :geek:
 
Upvote 0

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top