array instead of replace feature?
1. how big of a range are you talking about?
2. find is very fast in my opinion, post some code.
turn off calculation and screenupdating, execute your find, then turn it back
on.
--
Gary
"MasOMenos" wrote in message
...
Is it possible to use an array to load a range, find a value and replace it
with another value, and return the range back to the original cells?
Using the find/replace feature is very slow.
Thanks!
|