Delete a row if blank cell
 

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200605/1

Delete a row if blank cell
 

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

"mohd21uk via OfficeKB.com" <u20517@uwe wrote in message
news:5fbe443b2a83b@uwe:

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200605/1