» 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:
Recommended Books:
- Financial Modeling - 2nd Edition
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- The Analysis and Use of Financial Statements
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Marketing Plans
- A Mathematician Plays the Stock Market
No comments have been submitted.
