Deleting rows with specific criteria

11-21-2013, 01:16 PM

Pecoflyer

Windows 7 64bit Deleting rows with specific criteria

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,920

Pecoflyer has a reputation beyond repute

Quote:

If it's not sorted that way, and you don't want your program to sort it that way, then your program will just have to run down all the rows, deleting the ones where D is blank.

A looping can take very long and is often ineffeicient, this small piece of code will delete all rows where cells in col D are blank. I leave it to you to add it to your code

Code:

Sub QuickCull()
On Error Resume Next
Columns("D").SpecialCells(xlBlanks).EntireRow.Delete
End Sub

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge to create specific number of table rows	flackend	Mail Merge	4	12-01-2023 02:49 PM
Grouping table rows to prevent individual rows from breaking across pages	dennist77	Word	1	10-29-2013 11:39 PM
Print attachment when it arrive in specific folder with specific subject	visha_1984	Outlook	1	01-30-2013 10:42 AM
Count rows and add blank rows accordingly	Hoochtheseal	Word VBA	1	01-29-2013 09:23 PM
Adding columns in specific rows only	mhays	Excel	5	01-17-2012 09:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:07 AM.