Blank cell not recognised as blank

[chrisellis250]

Hi all,

So I have a table in Cells BA25:BD33.


The top row is the headers, with data being copied into BA26:BB33 - the others columns are generated with match formulas based on what is copied into BA and BB.


The data copied into BB is from a PIVOT table, so there could be 1 number copied into BB or 8 numbers.

However, the issue i have is when running this code:

Please Login or Register  to view this content.

If there is only one number copied into BB, not all of the rows are deleted from the table as there is always one value in BB that is not recognised as blank, because a blank cell from the pivot table is copied into the table.

Is there a way to amend my code so that Excel recognises the "empty" cell as blank?

[romperstomper]

Just loop through the cells:

Please Login or Register  to view this content.