T
Thulasiram
Hello all,
Code given below deletes the comments in all the cells in the
worksheets.
How to modify the code such that comments in the cell A2 and B1 of EACH
sheet is not deleted but delete all the other comments in the
worksheet?
Dim sh As Worksheet
Dim cmt As Comment
For Each sh In ThisWorkbook.Worksheets
For Each cmt In sh.Comments
cmt.Delete
Next
Next
Thanks,
Thulasiram
Code given below deletes the comments in all the cells in the
worksheets.
How to modify the code such that comments in the cell A2 and B1 of EACH
sheet is not deleted but delete all the other comments in the
worksheet?
Dim sh As Worksheet
Dim cmt As Comment
For Each sh In ThisWorkbook.Worksheets
For Each cmt In sh.Comments
cmt.Delete
Next
Next
Thanks,
Thulasiram