Mona,

try:

If .Cells(iRow + 11, 1).Value #06/01/2002# Then
.Cells(iRow + 11, 22).Value = "0"
End If


--
Hope that helps.

Vergel Adriano


"Mona" wrote:

I have a sample bit of code:

If Cells(iRow + 11, 1).Value < date_L119 Then
.Cells(iRow + 11, 22).Value = "NP"
End If
which works great !!

This doesn't work. How do I define my dates?

If .Cells(iRow + 11, 1).Value "06/01/2002" Then
.Cells(iRow + 11, 22).Value = "0"
End If

thanks