How do I clear a bunch of comments (if they exist !) from a Range of cells ? Thanks
I Isis Jun 22, 2010 #1 How do I clear a bunch of comments (if they exist !) from a Range of cells ? Thanks
D Doug Robbins - Word MVP Jun 23, 2010 #2 If you are talking about in Word, the following will clear all of the comments from the selected range Dim i As Long With Selection.Range For i = .Comments.Count To 1 Step -1 .Comments(i).Delete Next i End With If you mean in Excel, you should ask in http://social.answers.microsoft.com/Forums/en-US/officeprog/threads
If you are talking about in Word, the following will clear all of the comments from the selected range Dim i As Long With Selection.Range For i = .Comments.Count To 1 Step -1 .Comments(i).Delete Next i End With If you mean in Excel, you should ask in http://social.answers.microsoft.com/Forums/en-US/officeprog/threads
