Using Excel Application Functions in VBA : Excel Buildin Function « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Excel Buildin Function

Using Excel Application Functions in VBA

 
Sub func()
    Debug.Print Application.WorksheetFunction.Power(2, 3)
    Debug.Print Application.WorksheetFunction.Average(5, 7, 9)
    Debug.Print Application.WorksheetFunction.StDev(3, 7, 11)
End Sub








Related examples in the same category

1.Use function from Excel
2.Payment Function:Pmt (interest, term, principal, future value, type)
3.Cleans up every selected cell: with Proper function
4.Calculate a moving average
5.Sum a Range
6.Call worksheet function directly