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