Delete Clusters that are Fully White

Hi,

I'm working on a project and am particularly new to the whole excel world (especially with macros). Currently, my boss has some data that needs to be refined and organized. Until I get a sense how to have a macro do everything all at once, I plan on have macros do each step more quickly.

Right now, the macros my boss has given me allows the data to be organized into clusters. Each cluster is separated by client IDs in column C with a header "ID". Each cluster is separated by a blank row. We are looking for clients who have not paid their dues and are marking their unpaid dues with colored rows. The dues that are paid are left as white. However, there are clients who do pay their dues, leaving their entire clusters white. I was wondering if there is a macro to remove those fully white clusters.

Thanks!

Form above, I gather that for the rows you want deleted:

1. the ID in Column C will not be blank, and
2. there will be no interior color at the respective Cell in Column C; whereas all the other rows (that are not to be deleted) will have some interior color.

Take a back-up of your workbook, and then try the following macro:

Please Login or Register  to view this content.

HTH!

Hi, sorry. Maybe it is me, but this macro doesn't seem to work for me when I run it. I read it and from how it sounds, it should work exactly how I wanted it to. The only edit I made was repalcing the "Sheet1" with the actual name.

Do you get any error when you run this macro? If so, please share the details.
Else, try replacing this line in the code

Please Login or Register  to view this content.

with this line

Please Login or Register  to view this content.

If it still doesn't work, please share your workbook.