eliminating blan rows between cells in a column cantaining data

		Microsoft Office Forums > Microsoft Excel > Excel Programming
eliminating blan rows between cells in a column cantaining data

02-28-2017, 11:45 PM

NoSparks

Windows 7 64bit eliminating blan rows between cells in a column cantaining data

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

If your data starts in A1 and there is nothing in column A below "eeee", this should work

Code:

Range("A1", Cells(Rows.Count, "A").End(xlUp)).SpecialCells(xlBlanks).EntireRow.Delete

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Merge duplicate rows but retain data from one column	Willem113	Excel	1	09-21-2016 05:42 PM
Macro for Column to Rows Data	brunssl2	Excel Programming	3	04-28-2014 07:07 AM
How to send several rows of data from one column to each recipient in one go	mikustykus	Mail Merge	14	09-30-2013 08:32 AM
Eliminating zeros, null values and negatives in a column	jannie	Excel	1	06-22-2011 07:03 PM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:25 PM.