If Range("K1").Value < "" And Range("K1").Value < "0000" And _
Range("M1").Value Now - 7 Then Range("K1").EntireRow.Delete

This will delete Row 1 when the 3 conditions are met.

Mike F
"DKY" wrote in message
...

How would I translate this into VBS?? I know what I want to do, but
don't know the proper way to do this.

If the value in column K<"" AND <"0000" AND the value in column
M"(Now()-7)" then delete the row.

Help???


--
DKY
------------------------------------------------------------------------
DKY's Profile:
http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=387731