To get the name of an excel cell?

To get the name of an excel cell?

Postby Armando » Sun Dec 13, 2020 1:59 am

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
User avatar
Armando
 
Posts: 3176
Joined: Fri Oct 07, 2005 8:20 pm
Location: Toluca, México

Re: To get the name of an excel cell?

Postby Natter » Sun Dec 13, 2020 8:44 am

Range names are stored here:

For Each x In Application.Names
MsgBox (x.Name)
Next
Natter
 
Posts: 1182
Joined: Mon May 14, 2007 9:49 am

Re: To get the name of an excel cell?

Postby Armando » Sun Dec 13, 2020 4:18 pm

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
User avatar
Armando
 
Posts: 3176
Joined: Fri Oct 07, 2005 8:20 pm
Location: Toluca, México


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 101 guests