Calculate Standard deviation in Excel

Scripting Forums AppleScript | Mac OS X
#1

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

#2

Use the evaluate command:


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

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