title: VBA How to copy the content of a cell without .Select
body: <p>I am writing a method that can take the <code>Target</code> and paste the cell exactly to another cell. The cell is a shipping label with some fancy formatting. Is there a way I can do it?</p>
  <p>Originally I have this:</p>
  <pre><code>Worksheets(&quot;Label&quot;).Range(&quot;A1&quot;).Value = Worksheets(&quot;Get Address&quot;).Range(&quot;A28&quot;).Value
  </code></pre>
  <p>It worked for the plain text. However I lost the styling I created, they are different because after the first line, the style is different:</p>
  <blockquote>
  <p><img src="https://i.stack.imgur.com/f2UOf.jpg" alt="enter image description here" /></p>
  </blockquote>
  <p>I also tried to use Macro Recorder and I got a solution using <code>.Select</code>, and I <a href="https://stackoverflow.com/questions/10714251/excel-macro-avoiding-using-select/10718179#10718179">read this question</a> not to use it whenever possible. What can I do?</p>
  <pre><code>' Created by the Macro Recorder
  Range(&quot;A28:A33&quot;).Select
  Range(&quot;A33&quot;).Activate
  Selection.Copy
  Sheets(&quot;Label&quot;).Select
  Range(&quot;A1&quot;).Select
  ActiveSheet.Paste
  </code></pre>