title: Viewing cell address after calculation
body: <p>I have built the macro as following and it is working well. However, I have a problem with this. I want to see how the calculations in each cell was performed such as in "$B$6+A6" format in the original excel file but I am unable to do so. It would be really nice if you can help me out with this.</p>
  
  <p>Thank you very much</p>
  
  <pre><code>Sub RCinput()
  
  Dim a As Long
  Dim b As Long
  Dim c As Long
  Dim d As Long
  Dim e As Long
  
  
  
  
   a = InputBox("What is the row number: ")
  
   b = InputBox("What is the column number: ")
  
   c = InputBox("What is the last row number: ")
  
   e = b - 1
  
  
  For d = a To c
  
  Cells(d, b).Formula = Cells(d, e).Value * 2
  
  Next
  
  
  End Sub
  </code></pre>