mark hansen
Well-known Member
- Joined
- Mar 6, 2006
- Messages
- 534
- Office Version
- 2016
- Platform
- 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
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