Good afternoon trex46

...and welcome to the forum!!

Does something like this work out OK for you :
Range("A15").Formula = "=Sum(A1:A10)"
HTH

DominicB