Hi,

I think I am trying to do something quite simplistic, however my VBA writing skills are pretty poor.
I perform a calculation almost daily and it would be nice to have my own user defined function so that I don't have to write it out everytime..

I want a code that will allow me to select a group of cells, calculate both the Average and the Standard Deviation and then use the formula:

(StDev-Average)*100

Can anyone help? I've had a couple of goes but don't seem to be getting it right.

Thanks,
Toby