deleting comments in blank cells

**Fairport** · 05-06-2009, 12:22 PM

Is there a way to delete comments in a selected range of blank cells?

Thanks again in anticipation.

**royUK** · 05-06-2009, 12:59 PM

Something like

Please Login or Register  to view this content.

**JBeaucaire** · 05-06-2009, 01:04 PM

Like this:

Please Login or Register  to view this content.

**Fairport** · 05-06-2009, 07:18 PM

Thanks guys for both solutions, spoilt for choice now!! Both will be used in different parts of the project, (fair play and all that)

**shg** · 05-06-2009, 07:29 PM

Or ...

Please Login or Register  to view this content.

**royUK** · 05-07-2009, 02:17 AM

The code that I posted will clear comments fromany blank cells containing comments within the selected range. It doesn't loop through all the cells in the selection and so is potentially faster.

**Fairport** · 05-07-2009, 08:37 AM

Indeed royUK, it is faster. The spreadsheet I've inserted the code in has over 7500 data rows. The other method works well but is noticably slower. Thank you shg for your example, I'll try that one too when I get the oportunity.
Thanks everyone for your help on this one. So many routes to the same destination!

**royUK** · 05-07-2009, 01:17 PM

There's often several approaches to an Excel problem - it's always good to see different suggestions. You could avoid using Selection if you are working with all the data on a particular sheet - just use UsedRange