Find & Replace Very Slow in VB But Not Manually
Hi Jim
Thanks for the suggestion. I tried this out by there was no noticeable
decrease in execution time.
I cannot exactly understand why this takes so long but I guess it is
all the calculations that are required when I ressurect my dormant
formulaes - there are 14560 of them!
However it should only need to calculate them once which is after the
search and replace as I have calculation turned off.
Oh well - I might have to rewrite my whole approach.
Chrisso
|