Returning the range name in VBA
 

For the non-range name VBA code, I meant to write:

If ActiveCell.Address="$C$3" then DoSomethin

--
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