To get the name of an excel cell?

Post Reply
User avatar
Armando
Posts: 2479
Joined: Fri Oct 07, 2005 8:20 pm
Location: Toluca, México
Contact:

To get the name of an excel cell?

Post 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
SOI, s.a. de c.v.
estbucarm@gmail.com
http://www.soisa.mex.tl/
http://sqlcmd.blogspot.com/
Tel. (722) 174 44 45
Carpe diem quam minimum credula postero
Natter
Posts: 524
Joined: Mon May 14, 2007 9:49 am

Re: To get the name of an excel cell?

Post by Natter »

Range names are stored here:

For Each x In Application.Names
MsgBox (x.Name)
Next
User avatar
Armando
Posts: 2479
Joined: Fri Oct 07, 2005 8:20 pm
Location: Toluca, México
Contact:

Re: To get the name of an excel cell?

Post by Armando »

Natter:

Thank you, I'll try it.

Best regards
SOI, s.a. de c.v.
estbucarm@gmail.com
http://www.soisa.mex.tl/
http://sqlcmd.blogspot.com/
Tel. (722) 174 44 45
Carpe diem quam minimum credula postero
Post Reply