If you are talking about a worksheet formula, you can get around thi
limitation by defining named ranges. I was able to select 19 separat
(non-contiguous) cells and define them as a named range (not sure o
the max here since I do not use named ranges too often). So in theory
you could do that 30 times and get a STDEV for 19x30 = 570 points. I
some of them are next to each other, the number gets even higher.

If you mean in code, I believe you do not have that limitation with th
range object. I was able to select 50 different cells using the forma
Range("A1,A3,A5,A7,....A100").Select.



--
Message posted from http://www.ExcelForum.com