Hi
msgbox application.worksheetfunction.average(Range("C3:C9 "))

--
Regards
Frank Kabel
Frankfurt, Germany

"KiriumF1" schrieb im Newsbeitrag
...
Mm..how to write average worksheet function in VBA?
worksheetfunction.average?

How do I reference to the range of cells in another worksheet? Is it
like
this, WorksheetFunction.Average (Range("fulldata for c1")("C3:C9"))?

Thanks!