What is the syntax to add/delete comments?

‘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

 

 

Advertisements