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