title: Sum function and copying that result to another sheet
body: <p>I have a code that is to calculate the sum between two cells and then copy this result to another sheet, I would like the result to stay in f70 and then copy from there . But below code isnt work its put at 0 on input_6</p>
  <pre><code>wbMe.Sheets(&quot;blank3&quot;).Range(&quot;F70&quot;) = WorksheetFunction.Sum(Range(&quot;F68:G68&quot;))
  wbMe.Sheets(&quot;blank3&quot;).Range(&quot;F70&quot;).Copy
  wbMe.Sheets(&quot;input_6&quot;).Cells(3, Columns.Count).End(xlToLeft).Offset(0, 1).PasteSpecial Paste:=xlPasteValues
  </code></pre>