If F2<=500 then delete entire row

**Ajay45822** · 01-10-2021, 02:41 PM

Hi,

We have a file in that we have large data and we required a vba who can check

If F2<=500 then delete entire row

help pls

**BadlySpelledBuoy** · 01-10-2021, 02:50 PM

Here is one way using a loop.

Please Login or Register  to view this content.

If you have LOTS of rows of data then it may be quicker to use different methods such as filtering the data and deleting the visible rows.

BSB

**Ajay45822** · 01-10-2021, 02:59 PM

Thanks BadlySpelledBuoy,

its showing the error

run time error '6'

overflow

when we click on debug its goes on
For i = .Cells(Rows.Count, "F").End(xlUp).Row To 2 Step -1

**BadlySpelledBuoy** · 01-10-2021, 03:03 PM

Change "Integer" to "Long" and see if that works.

BSB

**Bo_Ry** · 01-10-2021, 03:09 PM

Please try

Please Login or Register  to view this content.

**Ajay45822** · 01-10-2021, 03:14 PM

thanks Bo_Ry

working

**truk2** · 01-10-2021, 03:21 PM

You only asked how to delete row 2 which is quite simple

Please Login or Register  to view this content.

But I assume that you actually want to check each row. Unfortunetly step down while deleting rows will likely lead to missing row that need to be checked.
Thus it is important to to start at the last row, and move UP the sheet.

Please Login or Register  to view this content.

If F2<=500 then delete entire row

LinkBack

Thread Tools

Rate This Thread

Display

If F2<=500 then delete entire row

Re: If F2<=500 then delete entire row

Re: If F2<=500 then delete entire row

Re: If F2<=500 then delete entire row

Re: If F2<=500 then delete entire row

Re: If F2<=500 then delete entire row

Re: If F2<=500 then delete entire row

Thread Information

Users Browsing this Thread

Similar Threads

delete entire row by vba if delete word is present

[SOLVED] delete entire row by vba if delete word is present

iCell.EntireRow.Delete not working. Need code to Delete Entire Row

[SOLVED] Macro Needed to Delete Entire Row if the Entire Row (Or Col A,B,C,D in row ) are blank

VBA code to delete the FILTERED range and moving the cell up (dont Delete entire row)

[SOLVED] Delete cell only with certain critria. Don't want to delete entire row, the celsl only

Delete entire row when cell says delete

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions