Macro No Longer Working

Hello All,

Long time lurk and reader first time poster.

I have a macro I have been using for a long time in numerous workbooks that cleans text in cells after the information updates from a CRM system I use. The CRM system uses Microsoft SharePoint and applies identifies after names (,#3459 for example). Anyhow, I wrote this macro and it has always worked but now it decided otherwise. I have checked all security settings and options and everything seems fine and I turn to you.

Please see below for my macro. I have checked the ranges in the macro and they are correct (Columns C:I). Any help is appreciated.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Thank you

Please explain what "doesn't work" means.

• Does the code run?
• Does it run but do nothing?
• Does it produce error messages? If so, what do the messages say?
• Does it produce unexpected/wrong results?
• Does it hang?

Also remember that this code is very specific to your data so we can't try it without having your file. It would be very helpful to attach a sample file if you cleanse any private data first.