Delete a row if blank cell

  • Thread starter mohd21uk via OfficeKB.com
  • Start date
M

mohd21uk via OfficeKB.com

I would like to delete a row if the the value in colmn I and H in the
respective row is blank. I would like to know if a macro can do this from the
start to the end of the worksheet.

Thanks.
 
J

JimMay

Good opportunity here to "record-a-macro";
1) Click inside of your data-table.
2) Macro, Record Macro - OK.
3) Data, Filter, Auto-Filter
4) Click on Down-arrow of Col-I header, select Blanks from list
5) Click on Down-arrow of Col-H header, select Blanks from list
6) In Row-selector column (the actual row nums col) click and
Drag over all currently selected rows; Edit, Delete entire row.
7) Unfilter to All for Col I and H.
8) Data, Auto-Filter - uncheck
9) Stop Macro record
HTH
 
Top