Logic

Topic

New Reply

This works for me:

If Range(“B” & rg) “65-03” Then
Range(“B” & rg).EntireRow.Delete
Else

But I also need to eliminate non blank items in M, so why does this not work?

If Range(“B” & rg) “65-03” And Range(“M” & rg) “”Then
Range(“B” & rg).EntireRow.Delete
Else

Am I missing something?

Reply | Quote

Replies

Change And to Or (and insert a space before Then):

If Range(“B” & rg) “65-03” Or Range(“M” & rg) “” Then

Reply | Quote

Grrrrrrrrrrr….

Thanks

Reply | Quote