title: How can I select a cell, given its row and column number?
body: <p>I am trying to select a cell by giving which row and column to use.</p>
  <p>It is giving me an error:</p>
  <blockquote>
  <p>&quot;Unable to get the select property of the range class.&quot;</p>
  </blockquote>
  <p>when I get to this line:</p>
  <pre><code>Sheets(&quot;Ticker&quot;).Cells(currRow, etfCol).Select.Paste
  </code></pre>
  <p>Here is a short snippet of my really long code:</p>
  <pre class="lang-vb prettyprint-override"><code>Dim etfCol As Integer, etfCount As Integer, currRow As Integer, currRowValue As String
  etfCol = 1   'Just select the first column
  etfCount = Sheets(&quot;Automated Table&quot;).Cells(Rows.Count, etfCol).End(xlUp).Row
  'Repeat for every row.
  For currRow = 5 To etfCount
      ''''''''''''''''''''''''''''''''''Copy and paste the ticker
      Cells(currRow, etfCol).Copy
      Sheets(&quot;Ticker&quot;).Cells(currRow, etfCol).Select.Paste
  Next
  </code></pre>
  <p>Am I getting this error because &quot;etfCount&quot; is the value I got from &quot;Automated Table&quot; sheet, and I am trying to use that for &quot;Ticker&quot; sheet?<br />
  This is the only reason I could think of, but that doesn't wholly explain this error.</p>
  <p>I tried debugging the code.</p>