Extracting defined names
 

How can I assign the defined name of a cell (the name assigned manuall
by Insert--Name--Define) to a variable in VBA

--
jsw4
-----------------------------------------------------------------------
jsw47's Profile: http://www.excelforum.com/member.php...fo&userid=3099
View this thread: http://www.excelforum.com/showthread.php?threadid=54725

Extracting defined names
 

If its a single cell name

Activecell.name.name

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"jsw47" wrote in
message ...

How can I assign the defined name of a cell (the name assigned manually
by Insert--Name--Define) to a variable in VBA?


--
jsw47
------------------------------------------------------------------------
jsw47's Profile:
http://www.excelforum.com/member.php...o&userid=30995
View this thread: http://www.excelforum.com/showthread...hreadid=547250

Extracting defined names
 

Try some code like the following:


Dim S As String
S = Range("C3").Name.Name
Debug.Print S



"jsw47"
wrote in message
...

How can I assign the defined name of a cell (the name assigned
manually
by Insert--Name--Define) to a variable in VBA?


--
jsw47
------------------------------------------------------------------------
jsw47's Profile:
http://www.excelforum.com/member.php...o&userid=30995
View this thread:
http://www.excelforum.com/showthread...hreadid=547250