My question would be:

What Range do you want to sum and where do you want the results entered.

If your going to use Vba why copy the formula?

Vba can just put the results of the formula in a Range

Like this script sums up the Range("A1:A10")

And puts results in Range("B1")

Code:Sub My_Formula() 'Modified 7/15/2019 3:19:44 PM EDT Dim ans As Long ans = Application.WorksheetFunction.Sum(Range("A1:A10")) Range("B1").Value = ans End Sub

## Like this thread? Share it with others