Select rows with cells containing consecutive blanks

Hi All,

I have created a large pivot table but need a macro to identify (and select) the rows in which there are two or more consecutive blank entries.

I have identified the days in which a customer base will make a purchase, but want to see any gaps of two or more days. Example below:

Highlight blanks.png

hi,

see attach file, make a Macro for sample.

Hi tranhieu04,

Thanks for this info! Can you please tell me how to change so this selects the entire rows that contain relevant cells, instead of highlighting?

Also, will this macro translate to a much bigger data set (B2:BH3000)?

See attach file for more detail.
press ALT + F11 to show modul

We are getting there! I have translated the macro to my workbook and changed the search parameters. Now all i need to do is change the highlight (interior colour) function to select the entire row that contains the cells.

Does that make sense?

Fixed it Suitable for a smaller range that you select with mouse for instance

Please Login or Register  to view this content.

Alf