» Delete rows with blank cells in a certain column using VBA in Microsoft Excel
CATEGORY - Cells, Ranges, Rows, and Columns in VBA
VERSION - All Microsoft Excel Versions
A tip to quickly and efficiently delete all rows that contain a blank cell in a certain column.
First select the single column range that you want to check, then execute this line of code:
Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
Book Store:
No comments have been submitted.
