‘add comments Range(“<cell reference>”).AddComment Range(“<cell reference>”).Comment.Text (“<your text here>”) 'deletes comments Range(“<cell reference>”).ClearComments ‘clear comments from a specific range Cells.ClearComments ‘clear comments from a worksheet