How to return NAME of the cell (not address, content, etc.)

Question

Let's say I name cell C4 as "TestCell", using NameManager or typing into the Name Box.

I want C5 to have a formula to return "TestCell" without the quotes.

I'll take VBA answer if that's necessary for this.

Try this: https://superuser.com/questions/683825/formula-return-cell-defined-name — Daghan, Feb 18 '20 at 12:10
Thanks Daghan, was really hoping for a simple formula but it looks like VBA is the way to go! — Dergyll, Feb 18 '20 at 12:14
the linked code creates a formula to use in Excel , so i guess you get a mix :-) — Daghan, Feb 18 '20 at 12:17

score 0 · Answer 1 · answered Feb 18 '20 at 14:36

0

This is what I was looking for, about a few hours of digging: How do you get a Range to return its Name?

use the .Name.Name method worked for me (using one .name gives only address).

Good luck!

answered Feb 18 '20 at 14:36

Dergyll

1 Answers1