VBScript for "control-shift-enter"

[taphonomist]

Hey all,
I'm trying to use a vbscript to do some matrix calculations in excel and having trouble figuring out how to apply the functions. When actually working in a workbook, you select the cells you need, type the array function (MINVERSE, eg), and then press control shift enter, but I can't find out how to do this from vbscript. Thanks in advance for the help.
Dustin

 

[taphonomist]

Got it!! Just had to set the range ArrayFormula property, rather than specifying the Value property.

http://msdn2.microsoft.com/en-us/li....interop.excel.range.formulaarray(VS.80).aspx

Dustin