title: Excel automation. How to copy more than one cell?
body: <p><strong>For instance:</strong></p>
  
  <pre><code> //omitted
  
  vector&lt;_bstr_t&gt; cellData;
  
  Excel::_WorksheetPtr pSheet = application-&gt;ActiveSheet;
  
  Excel::RangePtr pRange = application-&gt;Cells;
  
  _bstr_t cellValue = pRange-&gt;Item[1][1]; //single cell
  
  cellData.push_back(cellValue);
  
   //omitted
  </code></pre>
  
  <p><strong>Without:</strong></p>
  
  <ul>
  <li>MFC</li>
  <li>ATL</li>
  </ul>
  
  <p><strong>Question:</strong></p>
  
  <ul>
  <li>How to copy, <strong>multiple</strong> cells, for instance A1:B1, into the vector?</li>
  <li>Is there a more <strong>appropriate</strong> method, instead of <strong>Item</strong>?</li>
  </ul>