WorksheetFunction Help

[ajc5382]

I'm try to use the StDev function to calculate value. This is what I have so far but I continually get errors.
Any thoughts on whats going wrong with the following code?It's saying StDev is an invalid qualifier.

rngcorrel = Worksheets("config").Cells(32, 2) << # of days the stdev is taken over
correlcalc = WorksheetFunction.CountA(Sheets("INFO").Range("A:A"))


Do Until Worksheets("info").Cells(rngcorrel + i, 2).Value = ""

For i = 1 To correlcalc - rngcorrel
cor1 = WorksheetFunction.StDev("a1:a20").Value
Next i


Exit Do


Loop



Thanks so much,
AC

 

[Domenic]

Try...

[COLOR=#333333]cor1 = WorksheetFunction.StDev(Range("a1:a20").Value)[/COLOR]

 

[ajc5382]

Try...

[COLOR=#333333]cor1 = WorksheetFunction.StDev(Range("a1:a20").Value)[/COLOR]

Worked great, thanks!

 

[Domenic]

You're very welcome! Thanks for the feedback!