VBA Delete Row If Ciriteria From Multiple Columns are Met

**hobbiton73** · 08-19-2014, 01:54 AM

Hi, I wonder whether someone could help me please.

I'm trying to create a short script which performs the following:

Searches for a specific name in column C on my "Resource List" sheet, then

When this is found, check column H to see if this is populated,

Then when both criteria are met delete the entire row.

Using a link I found herehttp://www.ozgrid.com/forum/showthread.php?t=64364, I've put together the code below:

Please Login or Register  to view this content.

The problem I have is that although the criteria are being met the row is not being deleted.

I just wonderd whether someone may be able to look at this please and let me know where I'm going wrong.

Many thanks and kind regards

Chris

**hobbiton73** · 08-19-2014, 02:07 AM

***UPDATE***

All, thank you for taking the time to look at my post.

I just wanted to let you know I now have this working.

This row For iLoop = Last_Row To 1 Step -1 should have been For iLoop = LastRow To 1 Step -1 and I had column H as column 7 when it should have been column 8.

Many thanks and kind regards

Chris