Delete Row in VBA

[Ignition1]

What is the code I need to delete a row if that row contains a value in Column W which is other than "Live"?

So I tried -

If Columns("W").Value = "Dormant" Then EntireRow.Delete

Which is clearly wrong. I had a look on the net but it didn't help. Bit stumped on this one.

Edit - I should point out that "Dormant" is one of about 5 values which isn't "Live"

 

[VoG]

You are telling it to delete anything greater than 1/12/2012 =0.00004 approx.

Try

If Range("Z" & i).Value > DateValue("1/12/2012") Then Rows(i).Delete

 

[Ignition1]

In between posting and reading the answers I made a macro to convert dates into number, delete, then convert them back again.

No idea why I forgot to use DateValue.

I think I'm burnt out.

Thanks everyone.