Thread
:
Averaging a range in VBA
View Single Post
#
4
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Averaging a range in VBA
Am I missing something?
Why create a UDF to do what an excel function already does?
--
Don Guillett
SalesAid Software
"WilMar" wrote in message
...
Would someone be so kind as to get me started in the right direction.
Creating a UDF that initially needs to evaluate the average of a range,
however, Average is not a VBA function. I've tried the Evaluate function
with the worksheet function Average but my syntax must be wrong.
Is there an easy way or am I missing something. Here is the basis of
what I'm trying to do:
Function YearAvg(rng As Range)
YearAvg = Average(rng)
End Function
Thanks!
Bill
*** Sent via Developersdex
http://www.developersdex.com
***
Don't just participate in USENET...get rewarded for it!
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]