Delete is multiple conditions are met

**Poulan** · 10-05-2010, 01:28 PM

Hello,

I'm quite a novice here. I'm trying to delete rows where column C contains specific text in some instances. In other cases I am trying to delete rows where specific text is found in column C AND column M contains the year 2009 (in format dd-mm-yyyy).

The code I'm working with so far is as follows:

'This part is working OK
Sub DataProcess()

DataSheetProcess Macro

Sheets("Data").Select

LastRow = Cells(Rows.Count, 1).End(xlUp).Row

'start incrementing
For y = LastRow To 2 Step -1

'If Cells(y, "C").Value = "SANS" Then Rows(y).EntireRow.Delete
'End If

'If Cells(y, "C").Value = "NOVA" Then Rows(y).EntireRow.Delete '
'End If

'The following is not working correctly

If Cells(y, "C").Value = "DINERS MIGRATED MERCHANTS" AND EntryDate.Cells(y, "M").Value = 2009 Then
Rows(y).EntireRow.Delete
End If

Next y
End If

End Sub

**davesexcel** · 10-05-2010, 01:41 PM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

**davesexcel** · 10-05-2010, 01:42 PM

Once you have complete the first request....

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Delete is multiple conditions are met

LinkBack

Thread Tools

Rate This Thread

Display

Delete is multiple conditions are met

Re: Delete is multiple conditions are met

Re: Delete is multiple conditions are met

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions