Macro Search and Replace
Post code so we can look at it. there arre a few methods that you may be
using and without knowing the methods used in the code it is hard to give an
answer.
" wrote:
Our IT team was tasked in creating a Macro tool for Microsoft Excel
2003 that we had in our Word application but faced some problems in
executing the tool.
Below are the problems that were encountered:
a. Replace function limitations. If the cell has more than 180
characters, the program failed to replace the data.
b. Multiple replacements of data in one cell failed.
c. Changing of color for replace characters also failed.
The tool was to be customized to help our Editing team in polishing a
file that's been sent by our clients.
Any suggestions that could help us improve or speed up our process
will be truely appreciated.
Thanks,
Raymond
|