VBA Sum function and copying that result to another sheet

[Palucci]

Hello All,

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 my code put 0 i dont know why

wbMe.Sheets("blank").Range("F70") = WorksheetFunction.Sum(Range("F68:G68"))
wbMe.Sheets("blank").Range("F70").Copy
wbMe.Sheets("input_6").Cells(3, Columns.Count).End(xlToLeft).Offset(0, 1).PasteSpecial Paste:=xlPasteValues

 

[Palucci]

Alex !! Its working !! ah my hero ! :D

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help.
Having just "range" inside the sum formula means that it assumed it was referring to the ActiveSheet. That was obviously not the case, so I changed it to include the sheet specification.