if your talking about a collection as used by VBA, like Workbooks collection, then a collection is an Object not a numeric value, and cannot be used in that function

----- ksnapp wrote: ----

hell

i need the average of a collectio

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