sacacompany,
Can you describe what you are trying to accomplish? Perhaps an example showing before and after.
Then readers can offer some options on how it can/could be achieved.
The thread is marked SOLVED?? But seems problem persists.
Have you tried stepping through the code?
You have Option Explicit turned on?
Do you have MZ Tools to assign line numbers and use that with your error handler?
Further to the comments already posted, I'd like to know what questions you asked your CLIENT and what you committed to on receipt of these files.
You have almost 400 posts in this forum, I'm sure you must have agreed to something with your CLIENT.