Cell Names

[Bob]

Hi all:

In excel 2003 VBA, is there a way of knowing if a cell (or groups of cells)
have a name, and if so, what is that name? I know how to get all the
defined names, but not for a particular cell.

Thanks;

Bob

 

[Dave Peterson]

Dim myRng as range
dim myName as string
set myrng = worksheets("Sheet99").range("a1")

myname = ""
on error resume next
myname = myrng.name.name
on error goto 0

if myname = "" then
msgbox "no name"
else
msgbox myName
end if

 

[Bob]

Thanks Dave. I did not know you can use .Name.Name

Bob