Date question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Mona,

try:

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