Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Code Stage or method to enter Array Formulas to excel

DT
Level 4

‎26-06-19 12:18 AM

​Can someone assist with an OOB or code solution to entering an array formula to an excel cell ?
Thanks

------------------------------
DT
------------------------------
0 Likes
1 REPLY 1

GopalBhaire
Level 10

‎26-06-19 05:16 AM

Add a action to Excel VBO and set this in code stage where handle, cellref and formula are inputs

GetWorkbook(handle,Nothing).ActiveSheet.Range(cellref).FormulaArray = formula

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------
0 Likes