Deleting rows based on multiple filter options

cstimart

Well-known Member
Joined
Feb 25, 2010
Messages
1,180
Correct, the code is designed to Count # the Blank cells in B-F....if the total is zero (all cells have a value), it clears the value in Column A of the row....then the code deletes all the rows where column A is blank.

Therefore, since all the data is being deleted, that leads me to beleive that the Blank cells aren't truly blank.
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,089,214
Messages
5,406,886
Members
403,111
Latest member
Donbozone

This Week's Hot Topics

Top