» 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:
- The 22 Immutable Laws of Branding
- Microsoft Office XP Step-By-Step (With CD-ROM)
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Mastering Excel 2000 (for beginner)
- Fish! A Remarkable Way to Boost Morale and Improve Results
- The Ernst & Young Business Plan Guide
No comments have been submitted.
