VBA want to replace cell values and put a comment to show change

Hi!!!

I have this code
----

Please Login or Register  to view this content.

----
Its purpose: The code above changes some names for a holdings report so I don't have to do it manually
The issue: This is sent to other parties and I need to indicate which cells are change . I can't get my code to compile when I try to add a column script
Hope: To include comments to changed cells

Given it's a series of global replacements, I think you'll struggle to add comments. You could maybe use the global replacement to change the formatting ... maybe a different colour font.

Oh, and ...Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional.)

Use what you've got but use the option in the replace to change format.