title: VBA simple macro to copy formulas
body: <p>I would like to copy formulas from column into row. Formulas don't have $ signature in address so I cannot use special paste options, because it will change address in formulas of each cell. </p>
  
  <p>I try to run macro, but it copy only last cell from column to everyone one in row.</p>
  
  <pre><code>Sub Zamiana()
  For Each y In Range("A1:B1")
      For Each X In Range("A2:A3")
          y.Formula = X.Formula
      Next
  Next
  End Sub
  </code></pre>
  
  <p>Thanks in advance for help  :)</p>