VBA Code to Delete All Comments in Excel

This code deletes all the comments in the active worksheet.

VBA Code:

Sub DeleteAllComments()
    Dim comment As Comment
    
    For Each comment In ActiveSheet.Comments
        comment.Delete
    Next comment
End Sub

Check All VBA Codes

Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group

Leave a Comment