Calculate Standard deviation in Excel

Is there a way to calculate a STDEV in Excel without having to enter the result in an excel cell.

At present the best I can do is

tell application “Microsoft excel”
Set Formula of cell (“G20”) to “=STDEV.S(G3:G12)”
Set CheckF to value of cell (“G20”)
Set value of cell(“G2-“) to “‘
End tell

Thanks

Use the evaluate command:


tell application "Microsoft Excel"
	set stdev to evaluate name "=STDEV.S(G3:G12)"
end tell

Brilliant thanks very much, have not been able to find much about " evaluate name" but I assume an AppleScript command that will work with most excel functions.

Peter