We can access almost any Excel function through the Application object.
1. For example, place a command button on your worksheet and add the following code line:
Range(“A3”).Value = Application.WorksheetFunction.Average(Range(“A1:A2”))
When you click the command button on the worksheet, Excel VBA calculates the average of the values in Cell A1 and Cell A2 and places the result into cell A3.
instead of Application.WorksheetFunction.Average
we can also use