Thread: Clear formulae
View Single Post
  #17   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Clear formulae

Ain't newsgroups a neat way to learn?


Mike wrote:

"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


--

Dave Peterson