Hi Excel Gurus,
Can someone help me with a macro that will delete entire row if Cell on Column D is blank.
[Col D] [Col E] [Col F]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
The macro should only read starting row 12 to row 20 only. Any blank cell on Column D beyond row 20 will be ignored.
In the illustration above, the macro should only delete rows 18 and 20
Can someone help me with a macro that will delete entire row if Cell on Column D is blank.
[Col D] [Col E] [Col F]
Row 12 | Row 12 | Row 12 |
Row 13 | Row 13 | Row 13 |
Row 14 | Row 14 | |
Row 15 | Row 15 | |
Row 16 | Row 16 | |
Row 17 | Row 17 | Row 17 |
Row 18 | Row 18 | |
Row 19 | Row 19 | |
Row 20 | ||
Row 21 | Row 21 | |
Row 22 | Row 22 | Row 22 |
Row 23 | Row 23 | Row 23 |
Row 24 | Row 24 | |
Row 25 | Row 25 | |
Row 26 | Row 26 | |
Row 27 | Row 27 | Row 27 |
Row 28 | Row 28 | |
Row 29 | Row 29 | |
Row 30 | Row 30 | Row 30 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
The macro should only read starting row 12 to row 20 only. Any blank cell on Column D beyond row 20 will be ignored.
In the illustration above, the macro should only delete rows 18 and 20