title: VB.NET Copying Excel Range
body: <p>I have used the code below to copy an excel range.</p>
  
  <p><code>oSheetDestination.Range("A1:A10").Value = oSheetSource.Range("A1:A10").Value</code></p>
  
  <p>But I would like to copy the range based on the cell number location using something like this:</p>
  
  <pre><code>oSheetDestination.Range("1,1:1,10").Value = oSheetSource.Range("1,1:1,10").Value
  </code></pre>
  
  <p>Any ideas how I can do that? </p>
  
  <p>Thanks,</p>