FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour To get the name of an excel cell?
Posts: 3358
Joined: Fri Oct 07, 2005 08:20 PM
To get the name of an excel cell?
Posted: Sun Dec 13, 2020 01: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
Posts: 1392
Joined: Mon May 14, 2007 09:49 AM
Re: To get the name of an excel cell?
Posted: Sun Dec 13, 2020 08:44 AM

Range names are stored here:

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

Posts: 3358
Joined: Fri Oct 07, 2005 08:20 PM
Re: To get the name of an excel cell?
Posted: Sun Dec 13, 2020 04: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

Continue the discussion