title: VBA Syntax for Reference of a cell instead of cell value
body: <p>I want the VBA syntax for the reference of a cell instead of the value.</p>
  
  <p>I know that </p>
  
  <p><code>Workbook().Worksheet().Cell().Value</code> returns the value of the cell. </p>
  
  <p>I want to know the cell reference, something like this <code>='[Vba Source Test.xlsx]Source'!$B$8</code></p>
  
  <p>I tried using:</p>
  
  <pre><code>workbook().worksheet().cell().address 
  </code></pre>
  
  <p>but it only returns the <code>$B$8</code> part.</p>
  
  <p>I will be using it in a code like this.</p>
  
  <pre><code>Workbook(Master).Worksheet(Summary).range(a1).value =  
  workbook(Source).Worksheet(Data).cell(2,8).address
  </code></pre>
  
  <p>Thank you again for whoever can help.</p>