How can I delete rows based on specific criteria using a macro?

**akouleze** · 11-23-2011, 12:59 AM

Hi. I'm new to this forum so I'll get straight to the point. I need a macro that can go through all cells between P2 and P25000 and if the value is equal to 1 in any cell then I would like the entire row of this cell to be deleted. If the value is NOT equal to 1 then I don't need it to do anything. The name of my workbook is called "Historical Data" and I want this macro to run on "Sheet 2". If anyone could please write a specific code that I could simply copy and paste it into a new module without any editing I would greatly appreciate it as I'm not a programmer! Please use the data I provided here to create the code. As for the name of the macro please use "Test1". I definitively need a macro for this as doing it manually is not an option for me. Thank you very much for all your help!

**MarvinP** · 11-23-2011, 01:20 AM

Hi akouleze and welcome to the forum,

Try this code from the sheet you want to remove all rows that have 1 in column P.

Please Login or Register  to view this content.

**akouleze** · 11-23-2011, 09:38 PM

Thank you very much MarvinP!!!! It works great and really fast!!!

**royUK** · 11-24-2011, 02:49 AM

If the data is in a table format then automating AutoFilter would be fastr than a Loop

How can I delete rows based on specific criteria using a macro?

LinkBack

Thread Tools

Rate This Thread

Display

How can I delete rows based on specific criteria using a macro?

Re: How can I delete rows based on specific criteria using a macro?

Re: How can I delete rows based on specific criteria using a macro?

Re: How can I delete rows based on specific criteria using a macro?

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions