get rid of the parentheses around the "1": If Range("A1") = "1" Then..

--
protonLea

-----------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...fo&userid=3209
View this thread: http://www.excelforum.com/showthread.php?threadid=56772