Clear formulae
"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
|