title: VBA Excel - Update Cell value based on other cell value
body: <p>I am trying to write a formula in a  Range of cells based on other range cells values from another worksheet. The formula is shown below:</p>
  
  <pre><code>ActiveSheet.Range("G14:G43").Formula = "=Worksheets("1ºperíodo").Range("V14:V43").Value"
  </code></pre>
  
  <p>But the code doesn't work and I get a syntax error. That must be related with the strings but I don't know how to fix it. 
  The value  at <code>V14</code> must be equal to the value at <code>G14</code> until the last cell, i.e., the value at <code>G14</code> equals the value at <code>V43</code>. Besides the syntax error   is the formula correct based on what I expect to have?</p>