function referencing range to compute mean and stdev

[as_sass]

Hi all,

I wanted to create a user defined function that does a few computation
for which means and standard deviations of a range of cells ar
required. However, I don't know how to specify the input range and us
it in the computations.

The funtion should be able to do something like the following:

After a range is selected, compute mean and stdev of the value
contained therein. It should not return these values, but use them in
subsequent computation.

Can anybody help?

Thanks,

as

 

[Frank Kabel]

Hi
e.g. use
public function calculate_it(rng as range)
caluclate_it=application.sum(rng)
end function

You may take a look at
http://www.mvps.org/dmcritchie/excel/getstarted.htm