VBA code for automatic deletion of rows

srinivasarv

Board Regular
Joined
Mar 25, 2008
Messages
62
Hi,

I have the data as given below

Inward No. Bill No. Cheque No.
123 456 000

I need a vba code which should check the column cheque no. and if there is some data it should delete the full row and if it is blank then it should not delet the row.

Can anyone help me.

Thanks in advance

srini
<!-- / message -->
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Hi srinivasarv,

Not sure how many rows you have but if the dataset isn't too large (and assuming the data starts at row 2) the following will do the trick:

Code:
Sub Macro1()

    Dim lngLastRow As Long
    
    Application.ScreenUpdating = False

    For lngLastRow = Cells(Cells.Rows.Count, "C").End(xlUp).Row To 2 Step -1
        If IsEmpty(Cells(lngLastRow, "C")) = False Then
            Rows(lngLastRow).EntireRow.Delete
        End If
    Next lngLastRow
    
    Application.ScreenUpdating = True
    
End Sub

HTH

Robert
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,172
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top