» 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:
- Getting to Yes: Negotiating Agreement Without Giving In
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Marketing Management
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
No comments have been submitted.

