View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chua Chua is offline
external usenet poster
 
Posts: 8
Default How to write STDev formula in a macro

I have a list of data over 600 points to calculate the STDev.

Eg. Range A1:IR252 and Range A9:IR252

Anyone has idea how to write a macro to detect the different rows of values
and calculate the STDev using VBA?

Thanks