ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Custom functions or VBA functions for Avg, Std, Min, Max? (https://www.excelbanter.com/excel-programming/367378-custom-functions-vba-functions-avg-std-min-max.html)

ExcelMonkey

Custom functions or VBA functions for Avg, Std, Min, Max?
 
Sorry I posted this in the wrong newsgroup originally.

Does anyone know of any code for custom functions or VBA functions for Avg,
Std, Min, Max? I had been using the Excel functions (i.e.
application.worksheetfunction.) but have run into the 65326 contraint when
trying to apply these to an array populated by an Excel range. I need to
pass the VBA array to these VBA functions to get the Avg, Std, Min, Max.

Thanks

EM



All times are GMT +1. The time now is 06:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com