To put a formula =sum(D8:G8) into cell H8You would use Activesheet.range("H8").formula = "=sum(D8:G8)"