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"))
And we will be using two methods that are:
1: Range("A17").formula="=su
2: Range("A17").value = Application.worksheetfunction.sum(Range(
0 comments:
Post a Comment
Click to see the code!
To insert emoticon you must added at least one space before the code.