Loop through Column & delete entire row if Value is found

**lougs7** · 10-01-2018, 02:32 PM

Hi Guys,

I have a bunch of data in a spreadsheet (1000's of rows), I want to run a code that will loop through Column AC and if it finds the Cell value = "Spread" or & "Calendar Spread" than to delete the entire row.

A desensitized spreadsheet is attached for you reference.

Thank you!

**brant.wheeler** · 10-01-2018, 02:42 PM

Is there a reason you want a loop? The simplest way would be to do this using filtering. Also, I'm see "Spread" and "Calendar Spread" in column AD, not AC as mentioned. Please let us know which one is correct.

Thanks!

**lougs7** · 10-01-2018, 02:56 PM

I need it to be in VBA, I am not able to do this manually, it certainly can be a filter that deletes them, as long as the entire row with those strings in Column AC gets deleted

**dotchiejack** · 10-01-2018, 02:56 PM

Hi,
Try this, hope its meets your needs.
I took column B (2) assuming that there is always data in column B.

Please Login or Register  to view this content.

Loop through Column & delete entire row if Value is found

LinkBack

Thread Tools

Rate This Thread

Display

Loop through Column & delete entire row if Value is found

Re: Loop through Column & delete entire row if Value is found

Re: Loop through Column & delete entire row if Value is found

Re: Loop through Column & delete entire row if Value is found

Thread Information

Users Browsing this Thread

Similar Threads

Found?, then delete entire rows. Not found end sub

delete the entire row until column x if value '2' is found in column J?

[SOLVED] delete entire row when value is found

[SOLVED] Delete Entire Row if Blank is Found in Column

delete the entire row if duplicate found in column

delete entire row if 'value' found anywhere in column - most efficient way?

Need to compare 1 row in two worksheets and delete entire column if a match not found

Bookmarks

Bookmarks

Posting Permissions