Juan Pablo González
MrExcel MVP
- Joined
- Feb 8, 2002
- Messages
- 11,959
This is something interesting, and different ! check out Tommy Bak's solution here:
http://www.mrexcel.com/forum/excel-questions/70389-macro-find-replace-speed.html#post337963
where he uses the Dictionary object to come up with a fast solution !
The complete thread is here:
http://www.mrexcel.com/forum/excel-questions/70389-macro-find-replace-speed-2.html
Kudos to Tommy !
http://www.mrexcel.com/forum/excel-questions/70389-macro-find-replace-speed.html#post337963
where he uses the Dictionary object to come up with a fast solution !
The complete thread is here:
http://www.mrexcel.com/forum/excel-questions/70389-macro-find-replace-speed-2.html
Kudos to Tommy !
Last edited by a moderator: