View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
erickras erickras is offline
external usenet poster
 
Posts: 2
Default Find/Replace functions VERY slow when visibility = false

When trying to automate the find/replace functions I am running into an issue
where the process takes several minutes when I set the instance's visibility
property to false. The same process takes only seconds when I set the
visibilito to true.

A requirement is that this is kept hidden so I cannot leave the visibilty
set to true. I have also tried selecting and activating the range with no
difference in results.

Can anyone explain the reason why the visibility property has this effect on
the find and replace functions?