title: Excel VBA - Range.Copy transpose paste
body: <p>I am following the help menu for <code>PasteSpecial</code> but I cannot seem to get my code to work without an error.</p>
  <p>I want to take <code>Worksheets(&quot;Sheet1&quot;).Range(&quot;A1&quot;,&quot;A5&quot;)</code> and paste transpose to <code>Worksheets(&quot;Sheet2&quot;).Range(&quot;A1&quot;,&quot;E1&quot;)</code>.</p>
  <p>What is the most simple way to accomplish this?</p>