Clear comments from a range of cells

[Damo10]

Hi,

I am trying to clear the comments from a range of cells without much luck, can anyone offer some advice?

c.Offset(, 8).Resize(, 108).ClearComments

Regards,

 

[Michael M]

So just use Clear....not Clearcomment and not ClearContent

c.Offset(, 8).Resize(, 108).Clear

 

[Damo10]

Perfect, thank you