title: Excel VBA: Paste problems
body: <p>I have tried a variety of ways to do this paste, but none of them are working. I am extremely new to programming, so I need some help with understanding why I keep getting either error 1004 or 5. I don't even understand what these errors mean.</p>
  
  <pre><code>Cells(hotcell).Copy
  Cells.Offset(0, 1).PasteSpecial
  </code></pre>
  
  <p>or ...Paste, ...PasteSpecial = xlpasteall, ...pastespecial Paste:= xlpasteall, Range(Cells("B" &amp; i)).paste, Range("B" &amp; i).paste,  and so on as above.</p>
  
  <p>I'm at a total loss. Everything else in the program is working just fine. I just can't get it to paste my copied values into the desired cells (all offset by a certain number of columns, but in the same row). Help and explanation both appreciated.</p>
  
  <p><em>Edit</em> Thanks to BOTH of the answers I recieved, I was able to solve my problem. I really couldn't find a good answer anywhere I looked. Thank you!</p>
  
  <p>The solution I used was one of the simplest:</p>
  
  <pre><code>rng.Offset(0, 1) = rng.Text
  </code></pre>
  
  <p>Thanks again to the posters who answered, and the ones who commented. I was making it far too difficult.</p>