Deleting rows based on multiple filter options

[rochytall2000]

Hi, I need to review a 400,000 row spreadsheet and remove all records where 5 columns are populated with data so I am only eft with records that are missing information.

I haven't got the slightest clue how to go about this using VB.

Any and all help very much appreciated

 

[cstimart]

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.