In this excel vba programming tips and tricks tutorial # 2, we will be learning how to use the built-in Excel formulas in VBA. br And we will be using two methods that are: br 1: Range("A17").formula="=sum(a1:a16)" br 2: Range("A17").value = Application.worksheetfunction.