'deletes all of your user comments in an Excel spreadsheet

by Brandon (46 Submissions)
Category: Miscellaneous
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Fri 26^th October 2007
Date Added: Mon 8^th February 2021
Rating: (1 Votes)

API Declarations
Dim cmt As Comment Dim cmts As Comments

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



'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

Download this snippet Add to My Saved Code

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

No comments have been posted about 'deletes all of your user comments in an Excel spreadsheet. Why not be the first to post a comment about '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 Comments

Post your comment

Difficulty