Clearing contents

  • Thread starter Thread starter afdmello
  • Start date Start date
A

afdmello

I am having spread sheets with data, cell shading and in some cells comments

How do I go about all cell comments in a couple of key strokes at least

presently I am selecting individual cells> right click> delete comment

Any better way?

Afd
 
This macro will clear all comments from the selected area:

Sub clear_comments()
Selection.ClearComments
End Sub

Just select the cells with the comments in and run the macro.

Alternatively, if you don't want a macro in your workbook, select the
cells, then Alt-F11 to bring up the VBE, then CTRL-G to enter the
immediate window, and type:

Selection.ClearComments

and press <Enter>.

Hope this helps.

Pete
 
Back
Top