I’ve been trying to work through this problem with VBA macros, but I’m struggling.

My data set looks like this:

    A    B    C    D    E    F    G    H
21  X
22       X
23            X
24       X    X
25                 X    X
26  X    X    X    X

I want a macro which, given a range, will check certain columns for blank cells, and delete the entire row.

For example, in the data set above…

• Range A21:H26
• Check specified columns (let’s say A, B and C)
• If any of them are empty, delete the entire row

This should mean only row 26 wouldn’t be deleted as it contains values in all of the specified columns.

Thanks in advance