title: VBA Excel Macro: Offsetting Cell Selection, Selection as Defined by Macro
body: <p>I am writing a line of code as part of a more complex program that is not working correctly. I am new to VBA so please bear with me...</p>
  
  <p>Essentially, I am prompting the user to select a cell which is then assigned to the variable 'celNm'.</p>
  
  <p>I then perform the following actions:</p>
  
  <pre><code>celNm.EntireRow.Copy
  celNm.EntireRow.Insert
  </code></pre>
  
  <p>Next, for reasons specific to the program (and I am assuming the <code>celNm</code> will be located at the same cell after the command [Not the same location]), I want to move the cell selection upwards, so it is now located at the row just recently copied above. I am using the following line to do this:</p>
  
  <pre><code>celNm.Offset(-1, 0).Select
  </code></pre>
  
  <p>This, however, does not work.</p>
  
  <p>The next step in the program would be to create a list in this location. However the program still creates a list at the previous location (in the cell selected). Why is this? </p>