Hi Hardeep
Try the below and feedback...
Sub DeleteBlankRows()
Dim lngRow As Long
Dim intBlank As Integer
For lngRow = Cells(Rows.Count, 1).End(xlUp).Row To 1 Step -1
'Hide rows with blanks
If WorksheetFunction.CountBlank(Rows(lngRow)) = Columns.Count Then
intBlank = intBlank + 1
Else
intBlank = 0
End If
If intBlank = 2 Then Rows(lngRow).Delete: intBlank = 1
Next
End Sub
--
If this post helps click Yes
---------------
Jacob Skaria
"hardeep.kanwar" wrote:
Hi! to Everyone
There are many Software and Addin and Macro or Code to Delete or
Eliminate the Duplicate Data
But, I want to Delete The Duplicate BLANKS Row.I means to Say that
Delete Every Repeated Blank row
Example
Hardeep
Blank
Renu
Blank
Blank
ABc
Blank
DEF
Blank
Blank
Blank
Now i Want in this format
Hardeep
Blank
Renu
Blank
ABC
Blank
DEF
Blank
and so on,
Thanks in Advance
Hardeep Kanwar
--
hardeep.kanwar
------------------------------------------------------------------------
hardeep.kanwar's Profile: http://www.thecodecage.com/forumz/member.php?userid=170
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=108814