Hi Tim.

Try:

Application.Evaluate("Average(len(A1:X20))")

---
Regards,
Norman



"Tim Childs" wrote in message
...
I once saw the following code on the ng, which works fine of course!
?Application.Evaluate("max(len(A1:X20))")



When I try to use average (using worksheetfunction)instead of max, I
cannot
get it to work. Can someone provide the syntax or an explanation, please?

Thanks

Tim