• Home
 · 
• Miscellaneous
 · 
• 'deletes all of your user comments in an Excel spreadsheet

'deletes all of your user comments in an Excel spreadsheet

'deletes all of your user comments in an Excel spreadsheet

API Declarations


Dim cmt As Comment
Dim cmts As Comments



Rate 'deletes all of your user comments in an Excel spreadsheet

• 1
• 2
• 3
• 4
• 5

(2(2 Vote))

'removes all comments from your current spreadsheet
Set ws = Excel.ActiveSheet
Set cmts = ws.Comments
For Each cmt In cmts
   cmt.Delete
Next cmt
End Sub