Page 1 of 1

To get the name of an excel cell?

Posted: Sun Dec 13, 2020 1:59 am
by Armando
Hi Friends:

How can I get the name of an Excel cell or range of cells,
I don't need the contents I need the cell name

I tried with

oSheet:Cells(06,nCol):Name

but I get an error

Regards

Re: To get the name of an excel cell?

Posted: Sun Dec 13, 2020 8:44 am
by Natter
Range names are stored here:

For Each x In Application.Names
MsgBox (x.Name)
Next

Re: To get the name of an excel cell?

Posted: Sun Dec 13, 2020 4:18 pm
by Armando
Natter:

Thank you, I'll try it.

Best regards