title: VBA Excel - Reading data from another workbook
body: <p>So I'm just trying to call data from a cell in another workbook but my code is just returning "#name?" when I use "cells(3,3)". </p>
  
  <pre><code>Cells(1, 1).Formula = "='\\Drcs8570168\shasad\[CR Status.xlsx]Sheet1'!cells(3,3)"
  </code></pre>
  
  <p>However, this does work if I write it like this</p>
  
  <pre><code>Cells(1, 1).Formula = "='\\Drcs8570168\shasad\[CR Status.xlsx]Sheet1'!c3"
  </code></pre>
  
  <p>Can someone tell me why? 
  The thing is that I need to use something like cells() so that I can run this through multiple cells and assign the values to an array. Can someone please help me out? Thanks!</p>