xlcFormulaArray strange behavior and UDF

[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

 

[Earl Kiosterud]

Nic,

A UDF shouldn't be pasting anything into cells. I'm surprised you're
getting away with it.

Earl Kiosterud
www.smokeylake.com