Macro for calculation of Standard deviation-SIGMA from Range

[jovoga]

Hello,

Can anybody help me.
I need VBA macro code for do action :
Calculate STANARD DEVIATION value from range A1:A65535

Using formula is calculation very slow, i don`t know if macro will help me, but i wanna try.

Thanks for replies

 

[mikerickson]

Have you looked at the worksheet functions SDEV.P SDEV.S SDEVA SDEVPA

Native Excel functions usually perform better than their UDF emulators.