ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   XLL and user defined function + xlcFormulaArray (https://www.excelbanter.com/excel-programming/354935-xll-user-defined-function-xlcformulaarray.html)

[email protected][_2_]

XLL and user defined function + xlcFormulaArray
 
Hi all,

I'm wondering if there is any way to tell excel that our user define
function's result did'nt change.
In fact, this is because it takes a bit of time to process all my
results and to built the returning xloper.


Also, in a fonction called by excel, I'm using Excel4(xlcFormulaArray)
to paste a formula array in a range of cells.
The problem is that it seems to have the same behavior as
xlcCalculateNow because all my formula are trigged for a recalculation.
Is this a way to bypass that?

Thanks,

Nic



All times are GMT +1. The time now is 02:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com