I'm having some reliability issues with a "super-macro" I'm currentl
using. This macro -- which calls on several sub-macros -- is quit
process-heavy and operates on worksheets that often have thousands o
rows. Much of the "processing" involves search and replace or searc
and delete. E.g., replace "&" with "and".

Unfortunately, the "super-macro" will randomly miss a replace o
delete. The problem does not crop up frequently, but the results d
cause problems with programs this worksheet ultimately interface
with.

I have removed speed-optimizing code which I thought may be a culprit
I.e.:

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
[ your code ]

Application.ScreenUpdating = True
Application.Calculation=xlCalculationAutomatic

But the reliability remains unchanged.

Any info on how I can improve reliability is appreciated

--
KHashmi31

-----------------------------------------------------------------------
KHashmi316's Profile: http://www.excelforum.com/member.php...fo&userid=1043
View this thread: http://www.excelforum.com/showthread.php?threadid=38077