Failed to clear comments for a few cells

**billj** · 03-14-2017, 08:53 AM

Hi everyone,

I'm trying to clear comments for a few cells as below, but the code does not work. Do you know why?

Please Login or Register  to view this content.

**cytop** · 03-14-2017, 08:59 AM

Please Login or Register  to view this content.

You'll also need to check the cell actually contains a comment or it'll error...

**Arkadi** · 03-14-2017, 09:00 AM

Hi blillj:

The syntax to specify specific cells in the range is:

Please Login or Register  to view this content.

but, if the range is contiguous as in your code (wasn't sure if it is just an example or the real code), I'd use:

Please Login or Register  to view this content.

**Arkadi** · 03-14-2017, 09:12 AM

As cytop wisely pointed out, you will get errors when there are no comments, perhaps:

Please Login or Register  to view this content.

**xlnitwit** · 03-14-2017, 09:24 AM

Or simply this

Please Login or Register  to view this content.

**Arkadi** · 03-14-2017, 09:26 AM

@ xlnitwit, lol... I hate not thinking of the obvious! Nice job.

**xlnitwit** · 03-14-2017, 09:29 AM

Thank you. Sometimes it's good to have a brain that only thinks in straight lines!

**billj** · 03-14-2017, 10:00 AM

Many thanks, everyone. It works perfectly now

**Arkadi** · 03-14-2017, 10:06 AM

You're welcome, thanks for marking as solved, the rep, and the feedback

Re: Failed to clear comments for a few cells