title: VBA Excel - Take range of few columns
body: <p>I want to read data from columns by for loop. It should starts on B2 and ends on G2. I want to read B2 value as a string, and put another value to G2 cell. I use cellValue variable as Range type, and deviceName to take out this value of cell (cells(1) because first cell in this cellValue range).</p>
  <p>However I have got error like this:
  &quot;Invalid procedure call or argument&quot;</p>
  <pre><code> For Row = 2 To rows
          cellValue = ActiveSheet.Cells(&quot;B&quot; &amp; CStr(Row) &amp; &quot;:&quot; &amp; &quot;G&quot; &amp; CStr(Row))
          deviceName = cellValue.Cells(1)
          
          // my code...
   Next Row
  
  </code></pre>