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