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?
|