title: Simply trying to paste the same string into a range of cells with Excel VBA
body: <p>I need to paste the same string value into every row of an excel spreadsheet. I have defined the string within a loop, via my vba code:</p>
  
  <pre><code>    StickName = Left(myfile, 9)
      ActiveCell.FormulaR1C1 = StickName
  </code></pre>
  
  <p>It seems so simple to fill each row with the same value and I could do this via looping, writing into each cell until I reach the bottom row of the data, but there must be a more elegant solution. Is there a way to name a range (which would be a single column of data, from row x to y, within my loop) and fill an entire range with the same string?  Then re-define the range and the string value for each iteration of the loop?  I have searched on <em>fill range with value</em> and other similar searches and scoured the answers, but I don't see anything that addresses what I'm trying to do.  Thank you for your help!</p>