E
ep
Hi,
I'm developing an addin for Excel 2003 in C# that loops through a range of
cells that contain formulas and, based on certain conditions, changes the
formula. The problem is, the formulas contain calls to my UDF's, so every
time I change the range.Formula property, it will jump right into my
functions and recalculate. I've tried setting the application.Calculation
method to xlCalculationManual, but it still continues to run the UDF as soon
as I set the formula property.
Is there anything else I can try? Or any reason why I should expect this
behavior?
thanks in advance
I'm developing an addin for Excel 2003 in C# that loops through a range of
cells that contain formulas and, based on certain conditions, changes the
formula. The problem is, the formulas contain calls to my UDF's, so every
time I change the range.Formula property, it will jump right into my
functions and recalculate. I've tried setting the application.Calculation
method to xlCalculationManual, but it still continues to run the UDF as soon
as I set the formula property.
Is there anything else I can try? Or any reason why I should expect this
behavior?
thanks in advance