P
Paul
Is the formlua referring to a circular reference. I.e is
the value dependant on its own cell value?
Is the formula Array Entered? CTRL & SHIFT & ENTER
What version of XL?
If XP, try using the formual auditing toolbar, and
checking the calculation steps. It may show the section
of the formula that is erroring.
If not, post the formula in the NG for all to see, you
may find that the problem is easy to see (for a fresh set
of eyes).
HTH Paul.
Post to all replys to Thread.
the value dependant on its own cell value?
Is the formula Array Entered? CTRL & SHIFT & ENTER
What version of XL?
If XP, try using the formual auditing toolbar, and
checking the calculation steps. It may show the section
of the formula that is erroring.
If not, post the formula in the NG for all to see, you
may find that the problem is easy to see (for a fresh set
of eyes).
HTH Paul.
Post to all replys to Thread.