Delete rows with date more than 48 hours with a condition..

[Kashyap]

In the below table I want to delete rows with dates more that 48 hours in
column K if column J="ABC"

Column J|Column K
ABC 29-01-09
ABC 30-01-09
ABC 30-01-09
MNO 31-01-09
MNO 31-01-09
ABC 03-02-09
MNO 03-02-09
MNO 31-01-09
MNO 01-02-09
ABC 04-02-09

 

[Kashyap]

Hi, I tried this, but there is an error in ' dte = Cells(i, "K").Value

 

[Dave Peterson]

What's in that cell?

Hi, I tried this, but there is an error in ' dte = Cells(i, "K").Value

 

[Kashyap]

I have dates in cloumn K and some names in column J.

I want to delete the rows in which date is within 48 hrs and name is ABC only.

date format is '02-02-2009 13:27:00'