View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Chrisso Chrisso is offline
external usenet poster
 
Posts: 110
Default 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