title: Excel VBA defining a .Range with .Cells
body: <p>I'm running into a problem trying to select/copy certain ranges within my worksheet. I've narrowed it down as best as I can.</p>
  
  <p>This works fine:</p>
  
  <pre><code>dataSheet.Cells(dRow, dataSheet.Range("IO_MODULES").Column).Select
  </code></pre>
  
  <p>This does not:</p>
  
  <pre><code>dataSheet.Range(Cells(dRow, dataSheet.Range("IO_MODULES").Column), Cells(dRow, dataSheet.Range("IO_MODULES").Column)).Select
  </code></pre>
  
  <p>This is what I'm trying to do:</p>
  
  <pre><code>dataSheet.Range(Cells(dRow, dataSheet.Range("IO_MODULES").Column), Cells(dRow, dataSheet.Range("MODULE_END").Column)).Copy Destination:= _
  dataSheet.Range(Cells(dataSheet.Range("MODULE_1").Row + i - 1, dataSheet.Range("D_COUNT").Column + 1), Cells(dataSheet.Range("MODULE_1").Row + i - 1, dataSheet.Range("DATA_COL_END").Column))
  </code></pre>
  
  <p>I seem to be misunderstanding the relationship between Worksheet.Cells and Worksheet.Range. What I need to do is be able to select a range of cells based on the row and column numbers of cells that I've named.</p>