not able to use stdeva in excel vba,please help

this line is giving me an error,please help me to troubleshoot

ActiveCell.Formula = "=STDEVA(range(" & """" & area & """" & ")"

here area is a string variable which is having the value it supposed to have just fine

So the main issue is syntax and more specifically the quotation marks I guess,any help is appreciated,even though I can use stdev I still like to use stdeva in my macro although the difference is very subtle

Thank You

Sourav Bhattacharya

you can try like

Code:

---

activecell.Formula ="=stdeva(" & range("myrange").Address & ")"

---