Seems to me the very simplest way would be to use
Application.WorksheetFunctions.StDev. If you do that, you can supply a
range... Oh, I see; it accepts only 30 values. I guess you'll have to run
through a loop doing the standard-deviation calculation.

So is it a loop that you're not sure how to write, or is it the standard
deviation itself? It seems to me it must be something about VBA macros,
because anyone who wants to use a standard deviation probably already knows
how to obtain it, right?

If so, what part of VBA macros are you unsure of? Have you ever written a
program at all? Ever written anything at all in VBA? I mean, where are we
starting?

--- "Chua" wrote:
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?