?Application.Evaluate("max(len(A1:X20))")

[Tim Childs]

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

 

[Norman Jones]

Hi Tim.

Try:

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

 

[Myrna Larson]

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"))

 

[Tim Childs]

Hi

Thanks for these responses

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"))