Excel VBA Programming Tips n Tricks # 2 | How to use Excel formulas in VBA

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

­m(a1:a16)"
2: Range("A17").value = Application.worksheetfunction.sum(Range(­"a1:a16"))