I am trying to automatically add a comment to each cell, to show when the cell was last changed. I have the following VBA,
which updates an individual cell's comments with "Last Modified (date)" whenever the cell content is changed. It works just fine if I enter a value into a cell, or copy and paste values of one cell to another cell. But it does not work if I change multiple cells, such as copying and pasting a range.![]()
Private Sub Worksheet_Change(ByVal Target As Range) With Target .ClearComments .AddComment ("Last Modified " & Date) .Comment.Visible = False End With End Sub
How do you get this to work on a range of cells?
Bookmarks