View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ExcelMonkey ExcelMonkey is offline
external usenet poster
 
Posts: 553
Default Custom or VBA Function for Avg, Std, Min, Max

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