hello

i need the average of a collection

val is the name of a collection, here is the line of code:

a = application.worksheetfunction.average(val)


I tried this and it get an run time error 1004 unable to get th
average property of the worksheet function.

Is there something wrong with my VBA or is it that I can't use
collection like this?

Is there a way to average a collection? I have tried to averag
numbers in the argument list and it works just fine

--
Message posted from http://www.ExcelForum.com