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

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

FWIW, I've found EVALUATE to be "flaky". One day it works, the next day it
doesn't. You can use most worksheet functions via this syntax

? Application.Average(Range("A1:X20"))


On Fri, 24 Sep 2004 22:59:33 +0100, "Tim Childs" wrote:

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

Hi

Thanks for these responses

Tim



"Myrna Larson" wrote in message
...
FWIW, I've found EVALUATE to be "flaky". One day it works, the next day it
doesn't. You can use most worksheet functions via this syntax

? Application.Average(Range("A1:X20"))


On Fri, 24 Sep 2004 22:59:33 +0100, "Tim Childs"
wrote:

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