Test for no valid criteria in autofilter

[1eyedjack]

I have a couple of lines of code that looks something like:

Please Login or Register  to view this content.

The range rDeletion is set to the whole of the autofilter data range (excluding headers), and the effect of the two lines of code is intended to delete any rows that have the value TRUE in the cell in column 44.

This works fine EXCEPT where there are NO values of TRUE contained in column 44, in which case the (undesired) effect is that it deletes all rows where the intention is that it should delete none.

How should I get around this, please?

[Palmetto]

You could test for true values with a simple count before running the filter:

Please Login or Register  to view this content.