I think you will need code.

"ccyarm" wrote:


When I type a reference in a cell, i would like to change the value of
that referenced cell.
Ex: I type "d4" in cell "n5". I would like then to enter "1" in d4.
Is it possible without using vb code?
Thanks,


--
ccyarm
------------------------------------------------------------------------
ccyarm's Profile: http://www.excelforum.com/member.php...o&userid=24715
View this thread: http://www.excelforum.com/showthread...hreadid=382794