| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Array Formula result to a variable in VBA (Leo)
Hi,
We know that for putting an arrya formula we use "Range.formulaArray" property. But what about if I need to use an array formula result in the context of my code (like myVar =workbook.formula) and passing it to my variable, without putting it on a cell: just like MyVar or myFunction = arrayformula(sth). Is there any way? please help. -- Thans & Best regards Leo, InfoSeeker |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide #VALUE! in result of array formula | Excel Worksheet Functions | |||
| Passing string as array variable (Pivot VBA) | Excel Discussion (Misc queries) | |||
| Passing formula value to variable, hide rows | Excel Programming | |||
| keep recursion result (a dynamic array) without using global variable | Excel Programming | |||
| Passing SQL Query Result Into A Variable | Excel Programming | |||
Threaded Mode
