His answer is not irrelevant. You cannot (without code) change the
value of one cell from within another cell, this is a fairly well
recognized situation. The best you can do is you set A2's value to be
contingent upon A1's value as Ardus has politely tried to show. You
could also have a little respect for people who try to help you for
free.
HTH
Die_Another_Day
naddad wrote:
Your answer is completely irrelevant.
--
naddad
------------------------------------------------------------------------
naddad's Profile: http://www.excelforum.com/member.php...o&userid=29817
View this thread: http://www.excelforum.com/showthread...hreadid=552285