title: Reading/Writing Data In Other Sheets Without Selecting First
body: <p>I've been having a bit of an issue with reading and writing data from other sheets.</p>
  
  <p>Whilst I can read and write single cells fine using:</p>
  
  <p>sheets(sheet Name).cells(x,y).value</p>
  
  <p>using:</p>
  
  <p>sheets(sheet Name).range(cells(x,y),cells(a,b)).value</p>
  
  <p>does not appear to work.</p>
  
  <p>Whilst this is easily worked around by simply selecting the sheet it does have a bit of an overhead and feels quite inelligent.</p>
  
  <p>The main purpose I require this for is reading and writing arrays to inactive worksheets, if anyone has an alternative i'd be exceptionaly gratefull.</p>
  
  <p>Cheers</p>