Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find replace in functions | Excel Discussion (Misc queries) | |||
Dynamic Find and Replace String Within Functions Based on Column Values | Excel Programming | |||
slow replace function | Excel Worksheet Functions | |||
How come replace is so slow? | Excel Discussion (Misc queries) | |||
Arrays to replace very slow loops ? | Excel Programming |