title: copy and paste one cell value to multiple cells
body: <p>If I work in my spreadsheed, without using any vba-code, I could select a single cell, copy, then select a bunch of cells, and paste. The result would be that all the target cells are filled with whatever value was in the source cell. </p>
  
  <p>How would I do this in vba-code?</p>
  
  <p><s>You would think the following would work because it mimics the behavior described above, but it doesn't. It will fill the top cell of the target range with the value and leave the rest of the cells empty.  </s></p>
  
  <pre><code>    Range("A1").Select
      Selection.Copy
      Range("B1:B12").Select
      ActiveSheet.Paste
  </code></pre>