Read More: How to Calculate Average in Excel (Including All Criteria)ģ Examples Involving the Average of an Array with VBA (Macro, UDF, and UserForm) And it’ll show the average of the given array, that is, 64.22. MsgBox "The Average of the Array is: " + Str(Average) In the end, you can add a Message Box to display the average. ⧪ Step 4 (Optional): Displaying the Average We’ll use the UBound function of VBA for this purpose. Dim Sum As Variantįor i = LBound(MyArray) To UBound(MyArray)įinally, we’ve to divide the sum by the total number of elements of the array. We’ll accomplish this by iterating through a for-loop using the LBound function and the UBound function of VBA.
Then we’ve to find out the sum of all the elements of the array. To calculate the average of the array, first, we’ve to declare the array. Let’s see how we can calculate the average of the array step by step. VBA Code to Calculate the Average of an Array (Step-by-Step Procedure)
0 kommentar(er)
