Custom functions or VBA functions for Avg, Std, Min, Max?

E

ExcelMonkey

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom or VBA Function for Avg, Std, Min, Max 1
Picking part of a cell based on cell contents 7
Autocomplete Custom Functions and functions arguments 1
How to calculate a Max / min in a matrix 1
UDF in Excel 2007 for Filter or Query 2
Help file for VBA custom function 2
Displaying the arguments of UDF in the spertip 3
Max of a range help 4

Top