Clearing contents

[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

 

[Pete_UK]

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

 

[herochenna]

Visit www.ExcelGoodies.Com