"Dave Peterson" wrote in message
...
If my formulas were non-contiguous, then that gave me bad results
(xl2002).

But I could loop through each contiguous area in the range and it
worked ok:




Dave,

It looks like I should have been a little more creative & thorough
with my testing. When I tested the code that I posted earlier, I just
tested it on two areas that contained the same complex formula (=1+1).
Lesson learned.


Thanks for letting me know,

Mike