xlcFormulaArray strange behavior and UDF

  • Thread starter nicolas.gendron
  • Start date
N

nicolas.gendron

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
 
Top