Returning the range name in VBA
 

Just the elegant solution I was looking for

--
John Tji
-----------------------------------------------------------------------
John Tjia's Profile: http://www.excelforum.com/member.php...nfo&userid=468
View this thread: http://www.excelforum.com/showthread.php?threadid=26848

Returning the range name in VBA
 

You have a good solution, but just to answer on of your questions.

Activecell.Name.Name

returns the range name if it has one, otherwise it raises an error.

--
Regards,
Tom Ogilvy


"John Tjia" wrote in message
...

Just the elegant solution I was looking for!


--
John Tjia
------------------------------------------------------------------------
John Tjia's Profile:
http://www.excelforum.com/member.php...fo&userid=4681
View this thread: http://www.excelforum.com/showthread...hreadid=268487