Clear comments in a selection

[Jos Vens]

Hi,

I have a simple question but can't find it: how can I easily clear all
comments of a chosen selection.

I tried:

Selection.clearcomments but it doesn't work (I wonder why)

I know with a for each statement, it could work but is there not a faster
way?

Thanks
Jos Vens

 

[Norman Jones]

Hi Jos

Selection.ClearComments worked for me

Is the worksheet protected perhaps?

 

[KL]

Selection.ClearComments
works for me. Can you post the complete macro?

Regards,
KL

 

[Jos Vens]

Right Norman,

it was, and now it works too! Thanks a lot

Jos

 

[Dave Peterson]

That one-liner worked for me.

Are you sure you had the correct selection (on the correct worksheet)??