title: VBA code that concatenates a letter and variable to create a cell reference
body: <p>I have a piece of code that determines the lowest row with data in it. I want to write to the cell underneath this row so that I don't overwrite old data, but I'm having trouble referencing this cell. To clarify, I already have code that determines, for example, that the 51st row is the lowest row to contain data. I need to correct my second piece of code which writes to the cell below that row:</p>
  
  <p>Note: The integer "highest" is the row number lowest on the table that contains data</p>
  
  <pre><code>    sh1.Range(Concatenate(",'B', (highest+1),")).Value
  </code></pre>
  
  <p>I also tried </p>
  
  <pre><code>    sh1.Range("B" &amp; (highest+1)
  </code></pre>
  
  <p>Finally, I checked several forums and they hinted that I should use indirect to create a cell reference, but I haven't had much luck with that. What would the correct way to do this be?</p>