Thread: Date question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mona Mona is offline
external usenet poster
 
Posts: 69
Default Date question

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