delete rows based on a criteria

**Ralem** · 05-12-2011, 02:45 AM

All,

Appreciate providing me with a code to delete rows in my sheet based on the values in column C :

If values in column C are from 40 to 50 then delete the rows containing these values.

Thanks

**arthurbr** · 05-12-2011, 02:49 AM

Hi

try using Data - Filter Autofilter - in col C select "Custom" from the drop down box
as conditions use "is larger or equal to 40"
check " and"
second condition "is smaller or equal to 50)
Activate filter

delete the rows and remove the filter

**Alf** · 05-12-2011, 03:24 AM

Or if you prefere a macro code:

Please Login or Register  to view this content.

Alf

**Ralem** · 05-12-2011, 05:34 AM

Yes Alf, I am looking for a macro code to do this.

Thank you very much

**Alf** · 05-12-2011, 06:47 AM

Glad to be of help.

Alf

delete rows based on a criteria

LinkBack

Thread Tools

Rate This Thread

Display

delete rows based on a criteria

Re: delete rows based on a criteria

Re: delete rows based on a criteria

Re: delete rows based on a criteria

Re: delete rows based on a criteria

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions