Tim - Why not try having a cell on your spreadsheet like A1 reference
the value in cell L2 and then make your M2 reference to cell A1 - so if
cell A1 is 1 - then M2 has to be something else. This should eliminate
the circular reference.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=494968