title: Row Number reference with VBA
body: <p>I have searched a bit for a VBA code that will list me a row reference and am not finding results. Perhaps I am missing what the actual term for it is?</p>
  
  <p>I have a list of names in Column A, starting at A2. Then what I would like is a listing of 1,2,3,4,5 going down Column B, starting from B2, until the names stop. </p>
  
  <p>I can do this as a formula but need to have the values set there by a macro in this case.</p>
  
  <p>Can this be done?</p>