delete row based on cell value vba

**1vision** · 11-26-2014, 12:00 AM

Examples11-25.xlsx

How you doing everyone. I need your help once again.

I want to delete rows based on a value that this in column P. Currently I have "ZZZ" to identify the deleted rows.
But I can change the value to anything(number or text). I just wanted to have a unique value so I can delete the entire rows based on that value and leave the rest.

My range of rows will never be defined due to it not being consistent.

Can someone help me with VBA code to make this possible. Let me know if I need to add more info.

Thanks for your help.

**sktneer** · 11-26-2014, 12:45 AM

You may try this code. The code will prompt you to input the criteria from column P so as per your sample sheet, when prompted, you will input "zzz" or "ZZZ" to delete all the rows where there is "ZZZ" in col. P.

Please Login or Register  to view this content.

Does this help?

**nilem** · 11-26-2014, 12:52 AM

Hi 1vision,
try this

Please Login or Register  to view this content.

**MarvinP** · 11-26-2014, 12:55 AM

Hi,

Here is some other VBA code that does what I think you want. It is a little easier than the above.

Please Login or Register  to view this content.

**1vision** · 11-26-2014, 01:30 AM

Thank you all. I will try all 3 codes. I will also learn from all three codes. Thank you. I will get back to you guys once I try them.

delete row based on cell value vba

LinkBack

Thread Tools

Rate This Thread

Display

delete row based on cell value vba

Re: delete row based on cell value vba

Re: delete row based on cell value vba

Re: delete row based on cell value vba

Re: delete row based on cell value vba

Thread Information

Users Browsing this Thread

Similar Threads

Delete Row # based on cell value

Delete row based on cell FORMAT (color, font, etc) (not based on cell value)

Delete row based on cell value

Delete row based on Cell value

Delete Row Based on Cell of Another

Bookmarks

Bookmarks

Posting Permissions