PDA

View Full Version : Worksheet Cell Calculation Order



mapkn
06-27-2008, 09:47 AM
Hello,

I have created several user defined functions (UDF) which are used on the same worksheet - some of them rely on calculations to be done by others. (I am using Excel 2002).

My problem is that when I recalculate the sheet, I obtain errors which I believe are due to the fact that certain UDFs cannot be evaluated (as they rely on calculations to be done by another UDF).

Is there an 'optimal' way to design the spreadsheet in order to avoid tsuch issues please ? Any help on this would be much appreciated. I understand there are some logical steps which Excel follows, but if there are several UDFs I'm not sure how well it deals with order of calcculation. I guess there is some best way to organise your worksheet.

Thanks in advance,

Mitul

Bob Phillips
06-27-2008, 11:02 AM
If your UDFs are properly structured, that is all ranges are passed by parameter not hard-coded in the UDF, and the same for variable values, you should be okay.