View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jrh jrh is offline
external usenet poster
 
Posts: 14
Default "If Not" with a date

Why doesn't this delete rows with dates before 1-1-03?

Thank you.

LstRow = Cells(Rows.Count, "A").End(xlUp).Row

For r = LstRow To 2 Step -1
If Not Cells(r, 4) = "12/31/02" Then Cells(r,
4).EntireRow.Delete
Next r

also how do I write an If not as above to delete anything
that is not a nonblank?

Thank you