I wrote a massive text replacement macro but it's very slow. my system info "Processor Intel(R) Core(TM) i7-2630QM CPU @ 2.00GHz, 2001 Mhz, 4 Core(s), 8 Logical Processor(s)". How can I optimize the VBA and make it replace the text faster.
Are you using the optimization code in your macro?
Sub YadaYada()Optimization = True__________________
your code to make things happen
__________________
Optimization = False ActiveWindow.RefreshEnd Sub