Delete Blank Rows Using Excel VBA (Fast and Easy)

Sometimes we export excel file that contain blank rows. If you try to delete these rows using filter and sort option they does not appears there. as you see in Image below:

There are two ways to delete blank rows :

1. Using VBA
2. Without VBA

Using VBA:

Step 1:  Open Excel File that Contain Blank Rows.

Step 2: Press ALT + F11 to Open VBA Window.

Step 3: Go to Insert Menu and Click on Module.

Step 4: Now Copy and Paste This Code in Module

Sub Removerows()
  i = 0
  For i = 10 To 56
 If Worksheets(1).Cells(i, 1) = "" Then
  Worksheets(1).Cells(i, 1).Activate
     Rows(i).EntireRow.Delete   
    End If
    Next i
End Sub

Note: For i = 10 To 56 Means Table Data Starts From 10th Row and Ends on 56th Row. You can change this value as per your requirements. 

Step 5: Click on Run Button to run module and you see all blank rows has been deleted from active Sheet.

Video Tutorial (English):

Video Tutorial (Hindi):