no really John....
1) User can enter a value both in A1 or A2 ...if he enters a value in
A1 then value in A2 changes, if he enters a value in cell A2 then value
in cell A1 changes....
2) so both A1 and A2 contain a formula but can also take values....(or
so it looks)
Thanks for taking a look at this.....
--
Jan Jansens
------------------------------------------------------------------------
Jan Jansens's Profile:
http://www.excelforum.com/member.php...o&userid=26982
View this thread:
http://www.excelforum.com/showthread...hreadid=406186