title: Which value of a cell is retained If I give two arguments for it?
body: <p>First I had filled with D2 value as B2*5 , Then I got the output as 10 since the value
  in my B2 cell was 2
  Then I created a command button and the code i written for the button was 
  Range("D2").Value=4
  My doubt is the value of D2 cell is 4 after clicking the button, Why don't it retain the 
  previous value of D2 as 10 (since B2 is still 2 and D2 is still B2*5) or it gives an 
  error?</p>