MrExcel Publishing
Your One Stop for Excel Tips & Solutions

array formula question


Posted by Adam on November 26, 2000 8:58 PM

i know when i want to change an array formula i have to hit control +shift+enter.

Is there anyway of editting an array formula in code. the equivalent of the above in code.

Thanks,

Adam K


Posted by Ivan Moala on November 27, 2000 12:50 AM

Adam

Use;
Selection.FormulaArray =" your formula"
or
Range("A1").FormulaArray = etc


Ivan